How to disable ALL constraints ?
From: Jannette <jannetteyiu_at_my-deja.com>
Date: Sun, 23 Jan 2000 05:56:37 GMT
Message-ID: <86e56h$17r$1_at_nnrp1.deja.com>
From Oracle documentation:
[Quoted] [Quoted] "Suggestion: ... it is a good idea to disable referential constraints when importing into an existing table. You can then re-enable the constraints after the import is completed."
Date: Sun, 23 Jan 2000 05:56:37 GMT
Message-ID: <86e56h$17r$1_at_nnrp1.deja.com>
From Oracle documentation:
[Quoted] [Quoted] "Suggestion: ... it is a good idea to disable referential constraints when importing into an existing table. You can then re-enable the constraints after the import is completed."
How do you disable contraints on ALL tables in one shot ? Can you do this through one of Ent. Manager tools or you have to do it in SQL+ ?
Thanks
jannette
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Jan 23 2000 - 06:56:37 CET