oracle sql level,ORA-00604: error occurred at recursive SQL level 1

Hi Lukasz

sorry for late reply, here is the o/p

SQL> SELECT owner, trigger_name, trigger_type, triggering_event, base_object_type FROM dba_triggers WHERE triggering_event LIKE 'CREATE%';

OWNER TRIGGER_NAME TRIGGER_TYPE

------------------------------ ------------------------------ ----------------

TRIGGERING_EVENT

--------------------------------------------------------------------------------

BASE_OBJECT_TYPE

----------------

WMSYS NO_VM_DDL BEFORE EVENT

CREATE OR ALTER OR DROP OR RENAME

DATABASE

SYS CDC_CREATE_CTABLE_AFTER AFTER EVENT

CREATE

DATABASE

OWNER TRIGGER_NAME TRIGGER_TYPE

------------------------------ ------------------------------ ----------------

TRIGGERING_EVENT

--------------------------------------------------------------------------------

BASE_OBJECT_TYPE

----------------

SYS CDC_CREATE_CTABLE_BEFORE BEFORE EVENT

CREATE

DATABASE

EXFSYS EXPFIL_RESTRICT_TYPEEVOLVE BEFORE EVENT

CREATE OR ALTER

OWNER TRIGGER_NAME TRIGGER_TYPE

------------------------------ ------------------------------ ----------------

TRIGGERING_EVENT

--------------------------------------------------------------------------------

BASE_OBJECT_TYPE

----------------

DATABASE

MDSYS SDO_ST_SYN_CREATE BEFORE EVENT

CREATE

DATABASE

Thanks.