adding/extending datafile for tablespace [message #475712] |
Thu, 16 September 2010 22:39 |
ko_aung
Messages: 8 Registered: July 2010
|
Junior Member |
|
|
Hi,
Recently, I'm encountering the ORA-01654 error.
I did some research and found out that I need to extend or add new datafile for that tablespace.
I'm working in RAC environment with ASM enabled.
I'm not very familiar with DB administration.
My question is
-Do I need to restart the DB after making the changes?
-Do I need to execute the commands on both nodes?
Cheers!
Regards,
ko_aung
|
|
|
|
|
Re: adding/extending datafile for tablespace [message #476213 is a reply to message #475716] |
Wed, 22 September 2010 02:08 |
ko_aung
Messages: 8 Registered: July 2010
|
Junior Member |
|
|
Hi BlackSwan,
I'd like to use the following cmd:
alter database datafile <datafile_name> resize <new_size>
How can I determine whether the new size is larger than the current?
Is there a way to find out the size set for the specific datafile initially?
Thanks.
Regards,
ko_aung
|
|
|
|