Home » SQL & PL/SQL » SQL & PL/SQL » Moving Clustered tables from one tablespace to another (toad 8.1)
Moving Clustered tables from one tablespace to another [message #304060] Mon, 03 March 2008 22:44 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi guys,
Can give me the correct syntax for moving clustered tables in SYS Schema of system tablespace to another tablespace

Thanks,
Re: Moving Clustered tables from one tablespace to another [message #304065 is a reply to message #304060] Mon, 03 March 2008 23:16 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
Do you think that Tables in the SYS or SYSTEM schema can be redefined?

I don't think so.

regards,

Re: Moving Clustered tables from one tablespace to another [message #304074 is a reply to message #304065] Mon, 03 March 2008 23:52 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can a system tablespace can be made to offline ,if means can u give me the syntax for it

Thanks,
Re: Moving Clustered tables from one tablespace to another [message #304083 is a reply to message #304060] Tue, 04 March 2008 00:08 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
For more information about tablespace please read it.

http://download-uk.oracle.com/docs/cd/A97630_01/server.920/a96524/c04space.htm

regards,
Re: Moving Clustered tables from one tablespace to another [message #304093 is a reply to message #304060] Tue, 04 March 2008 00:39 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still searching how to get rid of your corrupted block?

Don't post the same question in multiple topics.

No, you can't move SYS objects out of SYSTEM tablespace.
No, you can't take SYSTEM tablespace offline.
Yes, you have to rebuild your database if you have a corruption in a SYS cluster and can't restore from a backup.

Regards
Michel
Previous Topic: consuming web service using utl_dbws
Next Topic: convert clob to string
Goto Forum:
  


Current Time: Wed Dec 07 22:09:15 CST 2016

Total time taken to generate the page: 0.11153 seconds