Create disable trigger command by querying user_triggers table : user_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> SELECT   'ALTER TABLE ' || table_name || ' DISABLE ALL TRIGGERS;'
  2  FROM     user_tables a
  3  WHERE    EXISTS
  4  (SELECT  'X'
  5  FROM     user_triggers
  6  WHERE    table_name = a.table_name)
  7  and      rownum < 2
  8  ORDER BY table_name;

'ALTERTABLE'||TABLE_NAME||'DISABLEALLTRIGGERS;'
----------------------------------------------------------------
ALTER TABLE STUDENT DISABLE ALL TRIGGERS;

SQL>
SQL>








30.105.user_tables
30.105.1.Find out the names of the tables you own
30.105.2.Getting Information on Tables
30.105.3.Getting a list of your own tables
30.105.4.Create disable trigger command by querying user_triggers table
30.105.5.Query user_tables for a table name