Home » RDBMS Server » Server Administration » ORA-08103 (11.2.0.1 windows xp)
ORA-08103 [message #529997] Thu, 03 November 2011 21:03 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
I get the ORA-08103 error,how to deal with it?

SQL> desc prc.ax_log;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TRANS_ID                                  NOT NULL VARCHAR2(255)
 ACCESS_TIME                                        DATE
 IP                                                 VARCHAR2(16)
 MAIL_FROM                                          NVARCHAR2(255)
 MAIL_SUBJECT                                       NVARCHAR2(255)
 MAIL_SIZE                                          NUMBER(38)
 POLICY_ID                                          NUMBER(38)
 FILTER_ID                                          NUMBER(38)
 MAIL_FLAG                                          NUMBER(38)
 PROTOCOL_TYPE                                      NUMBER(38)
 SCORE                                              NUMBER
 INSERTTIME                                NOT NULL DATE
 ATT_COUNT                                          NUMBER(38)
 USER_ID                                            VARCHAR2(60)
 ISCOMPUTED                                         NUMBER(1)
 MONTHNO                                   NOT NULL NUMBER(6)
 PROVCODE                                           NUMBER(3)


SQL> Select *
  2    From prc.ax_log
  3   Where Inserttime >= Trunc(Sysdate - 1)
  4     And Inserttime < Trunc(Sysdate)
  5     And User_Id Is Not Null
  6     And Length(User_Id) > 20;
  From prc.ax_log
                    *
ERROR at line 2:
ORA-08103: object no longer exists
Re: ORA-08103 [message #529998 is a reply to message #529997] Thu, 03 November 2011 22:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
08103, 00000, "object no longer exists"
// *Cause:  The object has been deleted by another user since the operation
//          began, or a prior incomplete recovery restored the database to
//          a point in time during the deletion of the object.
// *Action: Delete the object if this is the result of an incomplete
//          recovery.
Re: ORA-08103 [message #530073 is a reply to message #529998] Fri, 04 November 2011 08:38 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
who does come across the issue?,would you shared your way to solve it?
Re: ORA-08103 [message #530087 is a reply to message #530073] Fri, 04 November 2011 10:53 Go to previous message
LNossov
Messages: 318
Registered: July 2011
Location: Germany
Senior Member
It can be a block corruption (s. Doc ID 8103.1). You can also open a service request at Oracle to your problem.


[Updated on: Fri, 04 November 2011 11:00]

Report message to a moderator

Previous Topic: space and clob's
Next Topic: Convert Enterprise Edition DB to Standard Edition
Goto Forum:
  


Current Time: Thu Apr 25 16:20:16 CDT 2024