| TABLESPACE MANAGEMENT [message #156553] |
Wed, 25 January 2006 13:20  |
nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA
|
Junior Member |
|
|
I have a few questions
1) What is the difference between
alter datafile '/u01/data/data01.dbf' autoextend on;
and
alter tablespace data '/u01/data/data01.dbf'
autoextend on;
2) I have a tablespace named data
How do i alter it to become autoextend on as it is not right now.
I am doing
alter tablespace data
rename datafile '/u01/data/data01.dbf' to '/u01/data/data01.dbf'
SIZE 700M AUTOEXTEND ON;
It is giving me an error:SQL not properly ended
Please let me know
Thanks,
N
|
|
|
|
| Re: TABLESPACE MANAGEMENT [message #156556 is a reply to message #156553] |
Wed, 25 January 2006 13:55  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
You should look at the sql reference which lists syntax diagrams for the various commands. As far as your first question, I'd guess that if you tried both commands, the second would not work because you perform datafile operations on datafiles unless the tablespace is a bigfile tablespace. Check out the syntax diagrams and then just test your commands on your test database. And renaming a datafile is different than changing its size.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
