Re: oracle partitioning issue

msreejith_at_yahoo.com wrote:
> Thanks Brian and Jim for your inputs.
>
> Both of your solutions require copying the data from a "new_table" to
> "old_table" using something like:
> INSERT INTO new_table SELECT * FROM old_table
>
> Would this work seamlessly... considering factors like rollback error
> and other applications querying the table whilst this operation is
> happening. Pls let me know if there are any precautions to be taken
> care of.
>
> Thanks a lot,
> Srm
>

If other users will be querying the table while you perform this operation, then those users may be affected. So consider using the DBMS_REDEFINITION package to perform an online reorg of this table.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown