Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unable to release space from table

Hi all,

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.

Thanks .

Naba J Neog

Former Member
Not what you were looking for? View more on this topic or Ask a question