Delete space from oracle to file system

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Andrea,

i did not do reorganization, my manager has did with out dropping datafiles, now we wants to delete the data files, can u tell me the procedure for dat i am new to the basis,

present table space

2.5tb---400gb free

we want

tablespace size

2.2 tb--- 100gb free,

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Andrena,

Thanks for your reply, could you send me the documents to my mail id karthikbasis26@gmail.com