I think that the table is synonym created in your schema on some other table
on other schema. You don't have rights on this table except select rights.
This is my opinion. Please check again......
Regards
Munish Bajaj
-----Original Message-----
Sent: Thursday, July 24, 2003 19:34
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Munish Bajaj
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).
