on 05-24-2013 7:17 AM
hi all,
our Manager asked me to a prepare procedure for reduce the table space. kindly help me for below issue.
PSAPSID size 2.5TB- 400 GB free(aftre table space reorganization)
means 2.1TB data fulled,
Our problem is a lot of disk size when we run full database backup .
we want only 100 GB free space, and we needs to delete remaining 300GB from oracle to filesystem .
kindly help me
Hi
probably you did a reorg without dropping datafile.
Try to read this thread
http://scn.sap.com/thread/794911
Let me know if you need more infos
a
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karthik
so tell to your manager to do not any more reorgs and leave this to you
It's a couple of years that i dont work with oracle but there is not a straight fwd way to that. You can try to resize your datafiles to a smaller size and, if you are lucky, you obtain what you desire otherwise you need to do another reorg.
Last time that it happened to me, i prepared a temporary tablespace and schedule activties as following:
move all the tables in the temp tablespace
resize the empty tablespace
move back all the tables in correct resized tablespace
create indexes
statistics
Do you like this?
Let me know
a
PS.:obviously the procedure is more complicated but i can provide you the example scripts to a pvt email
Hi Andrena,
Thanks for your reply, could you send me the documents to my mail id karthikbasis26@gmail.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.