Underlying DBMS error [ORA-02158: invalid CREATE INDEX option]

MoizIshfaq — Sun, 29 May 2011 11:37:54 GMT

Dear all,
I am facing problem when I try importing/copying a raster dataset form any source to my desired arcsde environment which is 64bit ArcSDE 9.3.1, Oracle 11g R2 and Win2K8 Server. I tried even the SDERASTER command but I always get same annoying message. ArcSDE log files also show the same error. Here is the detailed error message.

---------------------------
Paste Failed
---------------------------
Failed to paste USER1.RASTER_CATALOG1
Underlying DBMS error [ORA-02158: invalid CREATE INDEX option]
DBMS table not found [ORA-00942: table or view does not exist] [USER1.RASTER_CATALOG1][STATE_ID = 2797030]
The index passed was not within the valid range.
The index passed was not within the valid range.
---------------------------
OK
---------------------------

ArcGIS forums reported it as a bug in 9.3.1 as per the URL 'http://support.esri.com/en/knowledgebase/techarticles/detail/38470' and I even applied relevant patch for this bug but the result is same.

I was wondering if there is a way I can further diagnose or fix this issue. Other than this problem this ArcSDE environment works fine.

topic Underlying DBMS error [ORA-02158: invalid CREATE INDEX option] in Data Management Questions

Underlying DBMS error [ORA-02158: invalid CREATE INDEX option]