| SYSTEM TABLESPACE RESIZE [message #327400] |
Mon, 16 June 2008 05:22  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
