How to do the batch job (disable/enable constraint)
BEGIN
FOR c IN
(SELECT c.owner, c.table_name, c.constraint_name
FROM user_constraints c, user_tables t
WHERE c.table_name = t.table_name
AND c.status = 'ENABLED'
ORDER BY c.constraint_type DESC)
LOOP
dbms_utility.exec_ddl_statement('alter table ' || c.owner || '.' ||
c.table_name || ' disable constraint ' || c.constraint_name);
END LOOP;
END;
/
BEGIN
FOR c IN
(SELECT c.owner, c.table_name, c.constraint_name
FROM user_constraints c, user_tables t
WHERE c.table_name = t.table_name
AND c.status = 'DISABLED'
ORDER BY c.constraint_type)
LOOP
dbms_utility.exec_ddl_statement('alter table ' || c.owner || '.' ||
c.table_name || ' enable constraint ' || c.constraint_name);
END LOOP;
END;
/
select 'ALTER TABLE '||substr(c.table_name,1,35)|| ' DISABLE CONSTRAINT
'||constraint_name||' ;' from user_constraints c, user_tables u where c.table_name = u.table_name;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20500445/viewspace-708606/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- EXP-00091: Exporting questionable statistics
- How to re-install JVM
- How to do oracle database character set migration
- Get the below error after duplicating database
- ORA-01940: cannot drop a user that is currently connected
- How to get the TOP SQL
- Change the max extents of table
- Fix undo tablespace issue Errors
- Identify tablespace fragmentation
- ORA-00018: maximum number of sessions exceeded
