RE: do I have block corruption?

From: Munish Bajaj <mbajaj_at_quark.co.in>
Date: Thu, 24 Jul 2003 20:18:52 +0530
Message-Id: <26007.339445@fatcity.com>

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-----
From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net] Sent: Thursday, July 24, 2003 19:34
To: Multiple recipients of list ORACLE-L Subject: do i have block corruption?

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: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net

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: ListGuru_at_fatcity.com (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). Received on Thu Jul 24 2003 - 09:48:52 CDT