I am checking in some data and I get an ORA-14452 error by Oracle. 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. The logfile shows:
[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001]
S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete
[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 955 ORA-00955: name is already used by an existing object
[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
JECTID, SDE_STATE_ID, ROWID ORA_ROWID FROM BP.A37392 WHERE 1 = 2") Execute Immediate error (955).
Error when removing rows from the adds table
[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] DB_registered_table_restore_rows_from_lineage_by_rowid(): Error creating temporary table.
[Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001]
S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete
[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
n use
[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
n use
[Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43).
[Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43).
I see that the global temporary table above has been created and is valid.
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------------- ------------------- ------
TRE_WSUSER SDETEMP37392_906396 TABLE VALID
