Home » RDBMS Server » Server Administration » alter user system default tablespace ...
alter user system default tablespace ... [message #369290] Fri, 04 August 2000 13:42 Go to next message
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 Go to previous message
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
Previous Topic: How can Insert Time Value alone into Date field ?
Next Topic: Re: Copying database by FTP method
Goto Forum:
  


Current Time: Fri Oct 30 03:34:17 CDT 2020