Skip to Content

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

reorganize oracle table online


I have a very big table ( about 12GB in size , with index 16 GB) , this need to be reorg often, database ( Oracle 11G) is with dataguard enabled with log shipping to DR database, last time we did online with SQL statement , it took more than 24 hours.

Just wondering what is the best way to reorg this type of big table , is there any tool available for online reorg can do better job ? Is brspace is better option ?

Thanks in advance, reply will be appreciated

Al Mamun

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