Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to disable ALL constraints ?

Re: How to disable ALL constraints ?

From: DI Karl Heinz Hörmann <kh.hoermann_at_penta.at>
Date: Tue, 25 Jan 2000 04:12:56 +0100
Message-ID: <86j41t$ga$1@newsmaster01.magnet.at>

Jannette wrote <86e59n$18g$1_at_nnrp1.deja.com>...
>From Oracle documentation:
>"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+ ?

either have some scripts ready, *or*
once upon a time (several years ago) we used to select SQL-commands into Spool-Files we executed after 'spooling them off' - perhaps this might be a way ... selecting 'alter table ' || table_name || ' disable constraint ' || constraint_name || ';' from user_constraints where ... /-selection_criteria like constraint_type =? 'R' ... -/

regards Received on Mon Jan 24 2000 - 21:12:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US