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