Skip to Content

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

Is a re-organization of table needed to re-index a table

hi

I am deleting the records in DBTABLOG using a standard SAP program but the table space is not freed unless and until a re-org is done, I want to re-organize table DBTABLOG but online re-organization is not possible due to table's long raw field.

The index table of DBTABLOG also occupies a large size... about 60GB

Can I re-index the table without re-organizing the table DBTABLOG, please let me know.

replied

Hello Eric,

> with LONG RAW, you cannot reorg online.

you are right in the case of a table reorg .. but he asked for an index reorg.

Regards

Stefan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question