topic Re: ORA-14452 and ORA-00955 in Data Management Questions https://community.esri.com/t5/data-management-questions/ora-14452-and-ora-00955/m-p/60428#M3439 <HTML><HEAD></HEAD><BODY><SPAN>Did you ever find a solution?&nbsp; I have the same error (ORA-14452... unable to create global temporary table... "Error when removing rows from the adds table") when attempting to synchronize a 2-way replica.&nbsp; I've put a ticket into support but no word yet.</SPAN></BODY></HTML> Wed, 18 May 2011 18:17:03 GMT SteveSalas 2011-05-18T18:17:03Z ORA-14452 and ORA-00955 https://community.esri.com/t5/data-management-questions/ora-14452-and-ora-00955/m-p/60427#M3438 <HTML><HEAD></HEAD><BODY><SPAN>I am checking in some data and I get an ORA-14452 error by Oracle.&nbsp; We are using Oracle 11.1.0.6 with ArcSDE 9.3 with Service Pack 1 and the Compress with Concurrent Editors and Memory Allocation patches.&nbsp; The logfile shows:</SPAN><BR /><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001]</SPAN><BR /><SPAN>S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete</SPAN><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 955 ORA-00955: name is already used by an existing object</SPAN><BR /><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] S_execute_dmlsql ("CREATE GLOBAL TEMPORARY TABLE sdetemp37392_906396 ON COMMIT PRESERVE ROWS AS SELECT OB</SPAN><BR /><SPAN>JECTID, SDE_STATE_ID, ROWID ORA_ROWID FROM BP.A37392 WHERE 1 = 2") Execute Immediate error (955).</SPAN><BR /><SPAN>Error when removing rows from the adds table</SPAN><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] DB_registered_table_restore_rows_from_lineage_by_rowid(): Error creating temporary table.</SPAN><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001]</SPAN><BR /><SPAN>S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete</SPAN><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 14452 ORA-14452: attempt to create, alter or drop an index on temporary table already i</SPAN><BR /><SPAN>n use</SPAN><BR /><BR /><SPAN>[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 14452 ORA-14452: attempt to create, alter or drop an index on temporary table already i</SPAN><BR /><SPAN>n use</SPAN><BR /><BR /><SPAN>[Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43).</SPAN><BR /><SPAN>[Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43).</SPAN><BR /><BR /><SPAN>I see that the global temporary table above has been created and is valid.</SPAN><BR /><BR /><SPAN>OWNER OBJECT_NAME OBJECT_TYPE STATUS</SPAN><BR /><SPAN>------------------------------ ------------------------- ------------------- ------</SPAN><BR /><SPAN>TRE_WSUSER SDETEMP37392_906396 TABLE VALID</SPAN></BODY></HTML> Thu, 12 Aug 2010 22:03:45 GMT https://community.esri.com/t5/data-management-questions/ora-14452-and-ora-00955/m-p/60427#M3438 BryanAnderson 2010-08-12T22:03:45Z Re: ORA-14452 and ORA-00955 https://community.esri.com/t5/data-management-questions/ora-14452-and-ora-00955/m-p/60428#M3439 <HTML><HEAD></HEAD><BODY><SPAN>Did you ever find a solution?&nbsp; I have the same error (ORA-14452... unable to create global temporary table... "Error when removing rows from the adds table") when attempting to synchronize a 2-way replica.&nbsp; I've put a ticket into support but no word yet.</SPAN></BODY></HTML> Wed, 18 May 2011 18:17:03 GMT https://community.esri.com/t5/data-management-questions/ora-14452-and-ora-00955/m-p/60428#M3439 SteveSalas 2011-05-18T18:17:03Z