Home » RDBMS Server » Server Administration » SYSTEM TABLESPACE RESIZE (ORACLE 10g, WINDOWDS 2003)
SYSTEM TABLESPACE RESIZE [message #327400] Mon, 16 June 2008 05:22 Go to next message
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
Junior Member
Previously i have system tablespace of size 100gb (oracle 10g).
Unfortunately few big tables were created in system tablespace. Now I move user tables in users tablespace that leads almost 50gb free space in System TS.

Now I m trying to reduce size of System TS. When I issue command to resize System TS
It gives me error


Failed to commit: ORA-03297: file contains used data beyond requested RESIZE value


I tried Coalesce System TS. But all in vain

Please guide me how to reduce system TS

Regards,

Hasan Shaw
DBA
Pakistan
Re: SYSTEM TABLESPACE RESIZE [message #327417 is a reply to message #327400] Mon, 16 June 2008 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to NOT trying to do it. It is dangerous.
It is better to recreate the database, 1GB is sufficient for 99.99% of the cases.

NEVER put user objects in SYSTEM tablespace.

Also, next time DON'T put your title in UPPER case.

Regards
Michel

[Updated on: Mon, 16 June 2008 06:04]

Report message to a moderator

Re: SYSTEM TABLESPACE RESIZE [message #327554 is a reply to message #327417] Mon, 16 June 2008 22:22 Go to previous messageGo to next message
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
Junior Member
yeap i know its dangerous but i have to , no other option let.. i have to reduce the System TS size.
Re: SYSTEM TABLESPACE RESIZE [message #327558 is a reply to message #327554] Mon, 16 June 2008 22:27 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
hasanshaw wrote on Mon, 16 June 2008 20:22
yeap i know its dangerous but i have to , no other option let.. i have to reduce the System TS size.


You can't get there from here.
At the very least, you should make sure you have backups from which you can restore the database.
After you trash the DB, then you can rebuild it.
Previous Topic: very urgent ora-01157
Next Topic: Moving Indexes
Goto Forum:
  


Current Time: Fri Dec 09 09:58:57 CST 2016

Total time taken to generate the page: 0.10500 seconds