Home » RDBMS Server » Server Administration » accidental creation of tables in system tablespace
accidental creation of tables in system tablespace [message #62688] Mon, 09 August 2004 14:45 Go to next message
chetna
Messages: 21
Registered: July 2004
Junior Member
Friends,

Can we transfer tables from system tablespace to a user tablespace ?

(ex scenario: if there were some tables created by accident in the system tablespace and they have to be recovered)

Thanks

Report message to a moderator

Re: accidental creation of tables in system tablespace [message #62689 is a reply to message #62688] Mon, 09 August 2004 15:56 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Sure, just move the table and it's indexes to your new tablespace. The indexed must be rebuilt because the rowid's change when you move the table.

alter table emp move tablespace users;
alter index emp_pk rebuild tablespace users;

Of course you should also make sure that the user no longer has the privs to create anything in system TS.

Report message to a moderator

Previous Topic: how to calculate semaphore parameters
Next Topic: format of oracle datafiles --- binary or ascii ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 10:32:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.