1. æå¼sqlplusï¼å¹¶ç¨ç¸åºçç¨æ·è¿æ¥ã
2. æpagesize设大ç¹ï¼å¦set pagesize 20000
3. ç¨spoolæç¸åºçç»æ导å°æ件æ¶ï¼å¦
SQL> spool /home/oracle/constraint.sql
SQL> SELECT 'ALTER TABLE ' || table_name || ' disable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
SQL> spool off
4. å·²ç»çæäºå
å«ç¸åºè¯å¥çèæ¬ï¼ä¸è¿èæ¬æ件éçæååæåé¢æå¤ä½çè¯å¥ï¼ç¨ææ¬ç¼è¾å¨æå¼ï¼å¹¶å é¤æ²¡ç¨çè¯å¥å³å¯ï¼
温馨提示:答案为网友推荐,仅供参考