Reclaim Table space in APQD

[Former Member]

Hi experts,

In Our PRD server a table APQD size is around 64 GB and i delted all the data in APQD table via SAP Note 36781 - Table APQD is very large.

but he is showing the same 64 GB space.

to reclaim the space in this table only table reorganization is method.

Please suggest.

ECC 6.0 on ORACLE 10G

Regards,

Vivek

[Former Member]

This message was moderated.

[Former Member]

Hi,

1) if you still have data in the table, you need to reorganize the table with DB specific tools or with brtools. APQD contains LONG RAW fields, so you need to perform export/import for the table. The system should ideally be down during the operation.

2) if you don't have any data in the table, you can truncate it with sqlplus command

'truncate table APQD;'

BR,

Samuli

[Former Member]

after truncate space will be released or not?

[former_member189725]

You need to issue

TRUNCATE TABLE APQD DROP STORAGE;

as mentioned in the note 36781. This would release the extents allocated by the table APQD.

A simple truncate would not release the unused storage subsequently.

Also make sure you follow the steps in note 36781 to truncate the data.

Regards

Ratnajit

[Former Member]

thanks for this

i have  1 question i deleted lot of rows belonging to table APQD via SM35.

& tables size is appx 64 GB after executing this command

TRUNCATE TABLE APQD DROP STORAGE;

all 64 GB data will be released???

[former_member189725]

It will release all except a few KB.

Regards

Ratnajit

[Former Member]

thanks to all.

[Former Member]

Actually 'DROP STORAGE' isn't needed; it's default:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/general003.htm

[jairo_pedroza]

Hello Vivek,

Use transaction SE14 in order to get back space.

When you use SE14, it will drop and recreate table. So, it will be quickly and safe. Don't forget APDI table !!!

Regards,

Jairo Pedroza

[Former Member]

ok in se14 which option i choose deleted  database table or delete data.

in delete data---------------- it will drop and recreate table???

[jairo_pedroza]

Hello Vivek,

Select Delete data and click in Activate and adjust database. In ECC 6.0, it will drop table and recreate

Regards,

Jairo