Table (SICO.T_DUMMY) was found in GDB_ObjectClasses, but does not exist in the database. Skipping.
DBMS table not found [ORA-04043: object SICO.T_DUMMY does not exist]
This “warning” message is being displayed in the log while running the “pre-requisite” upgrade option in ArcCatalog.
You can still proceed with the upgrade since it’s an “orphan issue” . Remark: warning message are displayed in “Green” color in ArcGIS Desktop.
Solution:
Through SQLPLUS or other database management tools (TOAD, Sql Developer), re-create the table using sql command.
In our example case: CREATE TABLE SICO.T_DUMMY ( OBJECTID INTEGER NOT NULL );
Then connect in ArcGIS Desktop (ArcCatalog) using the schema owner where the table is stored in (in our example schema name is “SICO”).
You will find the table T_DUMMY , then delete it. This will clean SDE metadata.
Reference Links:
http://support.esri.com/en/knowledgebase/techarticles/detail/34050
http://forums.arcgis.com/threads/72827-Clean-up-orphaned-records-in-the-SDE-repository-tables