OraFAQ Forum: Server Administration » reduce the system tablespace size

Home » RDBMS Server » Server Administration » reduce the system tablespace size (oracle11g)

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

reduce the system tablespace size [message #518761]

Sat, 06 August 2011 06:14

ramchekuri
Messages: 5
Registered: December 2006
Location: hyd

Junior Member

hi,
Please let me know how to reduce the system tablespace size
my system01.dbf size is 6gb
i want reduce from 6gb to 2gb

RAMM

Report message to a moderator

Re: reduce the system tablespace size [message #518769 is a reply to message #518761]

Sat, 06 August 2011 09:58

Michel Cadot
Messages: 68633
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Remove all curstomers objects from it
2/ If you have audit, remove rows from or truncate sys.aud$
3/ Query dba_extents and dba_free_space to get the last part of each file of the tablespace, then you can immediately shrink the file to the last used block

After this there are few you can do without hiring someone experimented that can do it without injuring your database.

Regards
Michel

Report message to a moderator