Originally posted by aarroyob
Originally posted by ronnie
You dont have to worry about commit/rollback because its a DDL.

No rollback will be generated for this.

Hope this helps
Big temp is requiered for this operation. I think in your case is not the best option. Use copy, or just export the table in origin and import it in destiny with ignore=yes, constraints=no, indexes=no.

Cheers

Angel [/B]

You are right about temp angel. I should have mentioned that.

And yes export/import can be another way to do it.