ALTER TABLE table_name
DISABLE CONSTRAINT constraint_name;
select * from all_constraints
where owner = 'SCOTT'
and constraint_name = 'SYS_C007539';
select*from all_constraints
where owner ='SCOTT'and constraint_name ='SYS_C007539';
2023-01-08 21:02:04
ALTER TABLE table_name
DISABLE CONSTRAINT constraint_name;
select * from all_constraints
where owner = 'SCOTT'
and constraint_name = 'SYS_C007539';
select*from all_constraints
where owner ='SCOTT'and constraint_name ='SYS_C007539';