Re: oracle partitioning issue

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 Received on Sun May 21 2006 - 07:13:41 CDT