OraFAQ Forum: Server Administration » How to remove non_data_dictionary object from SYSTEM tablespace

Home » RDBMS Server » Server Administration » How to remove non_data_dictionary object from SYSTEM tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to remove non_data_dictionary object from SYSTEM tablespace [message #110352]

Sun, 06 March 2005 10:44

snow
Messages: 2
Registered: March 2005

Junior Member

Hi all,
I would like to ask about how to move or delete non_data_dictionary objects from system tablespace?

Thanks
Snow

Report message to a moderator

Re: How to remove non_data_dictionary object from SYSTEM tablespace [message #110359 is a reply to message #110352]

Sun, 06 March 2005 20:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can just move the tables
alter table < tname > move < tablespace >;
or
rebuild the indexes
alter index < index_name > rebuild tablespace < tablespace >;
the rest objects can be recreated.
OR export the user and import in another schema ( make sure user has NO resource priv and quota 0 on system tablespace but has his own default tablespace)

Report message to a moderator

Re: How to remove non_data_dictionary object from SYSTEM tablespace [message #110363 is a reply to message #110359]

Sun, 06 March 2005 22:23

snow
Messages: 2
Registered: March 2005

Junior Member

thanks, Mahesh Rajendran.
Now, it's done. Smile

Snow

Report message to a moderator

Previous Topic:	The procedure start kpuhhalo was not found in the dll OCI.dll
Next Topic:	Fixing Fragmentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:33:20 CST 2025