1 CREATE INDEX myIndex
2 ON myTab (myCol)
3 PCTFREE 1
4 STORAGE (
5 INITIAL 5M
6 NEXT 5M
7 MINEXTENTS 1
8 MAXEXTENTS UNLIMITED
9* PCTINCREASE 0)
10 /
ON POS (ACCT_NO)
*
ERROR at line 2:
ORA-08103: object no longer exists
i try to create a table with a join off of this column and I get the same error. I ran
alter table validate structure and didnt get any errors(do these errors log to a
table? I didnt see any docs on OTN about this?)
not much on metalink
I was able to do a 'create table as' and create a duplicate
of the table which suprised me...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
