title: Oracle PL SQL disable all constraints of database tables
body: <p>I try to disable all constraint of all database tables. The database is named "database_test". The performance is not a problem.</p>
  
  <p>I wrote a pl/sql script which give me all constraints with the table.</p>
  
  <p>My problem is : when I run the script SQL developper say me "ORA-00972: identifier is too long". But I use only the fields already defined in the database.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE DISPLAY_CONSTRAINT_DATABASE AS 
  BEGIN
      FOR i IN (SELECT DISTINCT OWNER, OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABLE' AND OWNER = 'DB_NAME')
      LOOP
          FOR j IN (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS WHERE owner = i.OWNER AND table_name = i.OBJECT_NAME AND CONSTRAINT_TYPE='R')
          LOOP
              dbms_utility.exec_ddl_statement('alter table "DB_NAME.' || i.OBJECT_NAME || ' DISABLE CONSTRAINT ' || j.CONSTRAINT_NAME);
          END LOOP; 
      END LOOP; 
  END DISPLAY_CONSTRAINT_DATABASE;
  </code></pre>