topic DB_EV* triggers problem in Data Management Questions https://community.esri.com/t5/data-management-questions/db-ev-triggers-problem/m-p/667300#M37843 <HTML><HEAD></HEAD><BODY><SPAN>We have ArcSDE 9.3.1 on server(Windows) with Oracle 11g database residing on another server(Linux) where we create our database.</SPAN><BR /><BR /><SPAN>The problem appeared in last week we cannot import or create any FC in DB through ArcCatalog and also we cannot drop any Business table because&nbsp; 9.3.1 creates triggers on every table in the database. They're called DB_EV_ALTER_ST_METADATA, DB_EV_DROP_ST_METADATA and DB_EV_RENAME_ST_METADATA.</SPAN><BR /><BR /><SPAN>My DB admin gave the SDE account "DBA_role".</SPAN><BR /><BR /><SPAN>ORACLE Errors: ORA-04045 , ORA-01031.</SPAN><BR /><SPAN> </SPAN><BR /><BR /><SPAN>Is there any work around for this problem?</SPAN><BR /><SPAN>Why this problem happen suddenly ? , we did ( import , create and drop)&nbsp; before last week.&nbsp; </SPAN><BR /><BR /><SPAN>Regards,</SPAN></BODY></HTML> Sat, 06 Apr 2013 05:10:24 GMT NezarAl_Otti 2013-04-06T05:10:24Z DB_EV* triggers problem https://community.esri.com/t5/data-management-questions/db-ev-triggers-problem/m-p/667300#M37843 <HTML><HEAD></HEAD><BODY><SPAN>We have ArcSDE 9.3.1 on server(Windows) with Oracle 11g database residing on another server(Linux) where we create our database.</SPAN><BR /><BR /><SPAN>The problem appeared in last week we cannot import or create any FC in DB through ArcCatalog and also we cannot drop any Business table because&nbsp; 9.3.1 creates triggers on every table in the database. They're called DB_EV_ALTER_ST_METADATA, DB_EV_DROP_ST_METADATA and DB_EV_RENAME_ST_METADATA.</SPAN><BR /><BR /><SPAN>My DB admin gave the SDE account "DBA_role".</SPAN><BR /><BR /><SPAN>ORACLE Errors: ORA-04045 , ORA-01031.</SPAN><BR /><SPAN> </SPAN><BR /><BR /><SPAN>Is there any work around for this problem?</SPAN><BR /><SPAN>Why this problem happen suddenly ? , we did ( import , create and drop)&nbsp; before last week.&nbsp; </SPAN><BR /><BR /><SPAN>Regards,</SPAN></BODY></HTML> Sat, 06 Apr 2013 05:10:24 GMT https://community.esri.com/t5/data-management-questions/db-ev-triggers-problem/m-p/667300#M37843 NezarAl_Otti 2013-04-06T05:10:24Z