After adding the user I realized my script had mis-spelled the name, so I went back to DROP the user and recreate it. On one and only one database the DROP USER returned Failed to process SQL command - ORA-04088: error during executionoftrigger'MDSYS.SDO_NETWORK_DROP_USE...
Symptoms datapatch failed with follow error : 1) Error at line 160060: script rdbms/admin/prvtgwm.sql - ORA-04088: error during execution of trigger 'SYS.NO_GRANTS_2_END_USER_ROLE' - ORA-00604: error occurred at recursive SQL level 1 - ORA-06502: PL/SQL: numeric or value error - OR...
When running D1-UTCRN to generate Usage Transaction the following error is encountered;10:26:51,532 [VAMSAJOB2Worker:14] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-04088: error during execution of trigger 'SYS.XDB_PI_TRIG'ORA-00604: error occurred at recursive SQL level 2...
ORA-00604: error occurred at recursive SQL level 3 ORA-20997: Public grants on data schema objects not allowed ORA-06512: on line 23 ORA-06512: on "EXT_STAGE.EXCELTABLE", line 4087 ORA-06512: on line 11 00000 - "error during execution of trigger '%s.%s'" ...
ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 13 ISToci8.c:603:in oci8lib_250.so This was working fine for me and recently started happening.Owner...