SYSTEM TABLESPACE RESIZE [message #327400] |
Mon, 16 June 2008 05:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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 #327558 is a reply to message #327554] |
Mon, 16 June 2008 22:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 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.
|
|
|