Unable to release space from table
We are unable to release space from a table called TST03 even after deletion of records.
Followings are the information.
Database : 9.2
Table Name : TST03
Tablespace : LOCALY MANAGED.
Previously there were lots of rows.
At Present only 9 No of Rows.
Space allocated : 41 GB
PCT_INCREASE : Null
One of the column is of LONG RAW type.
Since the table is in LMTS, we were expecting that the space allocated will be released automaticaly after deletion of records.
Now, what are the option left with us to release 41GB of space ?
A. Is there any effect of "Drop storage" option of 'Truncate table' command ?
B. If yes , can i copy all the 9 rows to a new table, then use "Truncate table TST03 drop storage", check if space is released and then copy back all the 9 rows to this table.
C. Do you have any other easy solution apart from export/import ?
D. Checked all the relevant Note(646681,48400,10551), could not find an easy solution. I want to avoid offline export/import option.
Naba J Neog