My DBA set up a new Oracle instance for me (10g) and installed a brand new blank 9.3.1 SDE in it.
I'm connected as the SDE Admin and I started loading some sample layers into it (shapefiles) using the "Import Feature Class - Single" tool in ArcCatalog 9.3.1, just to play around and test things out.
With any shapefile I try to load, I get an error in the progress window that states "ERROR 000372: Spatial Reference for output is invalid, Please update to allow output to become valid
Failed to execute (FeatureClassToFeatureClass)."
However, the process doesn't actually fail - it does put the layer into the SDE and it draws like it should if I add it into an ArcMap view.
Searching the forums, I found an earlier thread where a suggestion was made to click "Tools-Options", then go on the Geoprocessing tab, click "Environments", then "Geodatabase Settings", and set Spatial Index 1 to a very large number like 50000. I tried that, but then if I load a layer I get an error stating "ERROR 999999: Error executing function.
Underlying DBMS error[Error executing PL/SQL Block db_stgeom_create_index::ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-00911: invalid character]
DBMS table not found[ORA-00942: table or view does not exist
Failed to execute (FeatureClassToFeatureClass)."
If I go back and change that index back to 0 in the Environments window, then I go back to getting the first error I mentioned, though as I said, it does actually put the layer in the SDE even though it says it failed.
Does anyone know what is going on here and how to fix it? I just completed some SDE training and am pretty new at this, but I don't remember a mention of anything like this in the class.
Thanks!
Jason M.
Conservation Data Analyst - NatureServe