alter user system default tablespace ... [message #369290] |
Fri, 04 August 2000 13:42 |
Rick
Messages: 49 Registered: March 2000
|
Member |
|
|
after db was created and went live, for some reasons, i did:
alter user system default tablespace ABC;
and did some works...
now, i am wondering if i can change it back:
alter user system default tablespace SYSTEM;
and
drop tablespace ABC including contents;
|
|
|
Re: alter user system default tablespace ... [message #369291 is a reply to message #369290] |
Fri, 04 August 2000 16:58 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
Yes you can...why confused? (but you will lose what all tables and indexes (and related objects) are created as system after setting the default TBS to ABC. When you are not using that objects anymore....bring it back to system and drop ABC)
sam
|
|
|