Re: Disabling Constraints

Here is a script which generates all of the 'alter table' statements to drop the referential constrains. Spool if or cut and paste and you should be all set. select 'alter table schema.'||table_name||' disable constraint '||constraint_name||';' from dba_constraints where CONSTRAINT_TYPE in

RE: Disabling Constraints

Ruth: Thanks, I found this to work also. ALTER TABLE 'TABLE_NAME DISABLE CONSTRAINGT CONSTRAINT_NAME; Ken -Original Message- Sent: Tuesday, November 27, 2001 7:00 AM To: Multiple recipients of list ORACLE-L Subject:Re: Disabling Constraints Here is a script which

RE: Disabling Constraints

PM Para: Multiple recipients of list ORACLE-L Asunto: Disabling Constraints I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient

Disabling Constraints

I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ:

Re: Disabling Constraints

To disable a constraint: alter table table-name disable constraint constraint-name ; should do the trick. Assuming you don't have any constraint violations, the following should work just fine to enable the constraint: alter table table-name enable constraint constraint-name ; Kent

Re: Disabling Constraints in a Schema!..??

Arul You can use the following generic script to disable all the primary key and the corresponding foreign key constraints. set pages 0 feed off spool fk_dis.sql select 'alter table '||table_name || ' DISABLE constraint ' ||constraint_name ||' CASCADE '||';' from user_constraints ; spool off

Disabling Constraints in a Schema!..??

Hi DBAs, We r using Oracle 8.1.6 . db. I would like to disable all the constraints on the Tables available under one schema. Is there any single command to do this in 8i . Any DBMS package available? Any other suggestions for doing the same?? Thank You. Arul. -- Please see the official

Re: Disabling Constraints in a Schema!..??

-- the FK select 'alter table '||table_name||' disable '||constraint_name||';' from user_constraints where constraint_type = 'R'; there is check constraints, primary key, and unique, but i'll not give you the entire answer. joe Arul kumar wrote: Hi DBAs, We r using Oracle 8.1.6 . db.