SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

disabling constraints while copying

523861Sep 11 2006 — edited Sep 12 2006

just a quick question I'm sure:

I'm copying data from one database to another I want the copy to ignore any
constraints on the target table.

copy from [schema]/[password]@[database] insert [schema].[table] -
using select * from [schema].[table] where [criteria];

is there something I can append to that to disable the constraints temporarily?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2006

Added on Sep 11 2006

7 comments

2,068 views