Hi all ,
Greetings.
I am on oracle 10G and OS Sparc.
I was looking for information on how to claim the space after dropping / truncating a table.
A.)I checked on net but i cannot test(Dev db unavailable) , so i am looking for your suggestion :
1. drop table tablename purge;
2. drop table tablename;
3. truncate table tablename reuse storage; --> drop table tablename;
Which one of the above will reclaim the space ?
B.)
Also , I have to purge the sys.aud$ table since its getting filled. Will doing truncate table sys.aud$ release the used tablespace ?
References:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:54178027703899
http://www.adp-gmbh.ch/ora/sql/drop_table.html
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9003.htm
http://www.orafaq.com/node/968
MOS Doc 73408.1 (How to Truncate, Delete, or Purge Rows from the Audit Trail Table SYS.AUD$)
Regards
Kk
Edited by: Kk on Jul 22, 2011 12:08 AM