Home » SQL & PL/SQL » SQL & PL/SQL » ORA error with object no longer exists
ORA error with object no longer exists [message #230781] Thu, 12 April 2007 15:30 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir

Actually sir

when i run this query in ur server i got this error

>select count(*) from <table_name>;

I get ora-08103: Object no longer exists

-->when i describe it seeme good
-->when i try with >select * from<table_name> also seems good

but it show same error when i try to run this query

>create table test as select * from <table_name>;
I get ora-08103: Object no longer exists

plz help what i do in this situation.

Thanx in advance...
Re: ORA error with object no longer exists [message #230782 is a reply to message #230781] Thu, 12 April 2007 15:53 Go to previous messageGo to next message
BlackSwan
Messages: 25045
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.

exit client s/w & then login again.
If problem persists, provide complete CUT & PASTE of whole session; instead of parphrasing what you saw.
Re: ORA error with object no longer exists [message #230907 is a reply to message #230781] Fri, 13 April 2007 05:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
My guess would be that someone else is creating and deleting either that table, or synonyms to that table.

I can think of no other way to explain the symptoms you describe, where a SELECT count(*) will work, and a SELECT * will error.

Please run the following commands in SQL*Plus and cout and paste the SQL and the results back here.
select count(*) from <table_name>;

select * from <table_name>;

create table test as select * from <table_name>;
Re: ORA error with object no longer exists [message #230935 is a reply to message #230907] Fri, 13 April 2007 07:50 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
thank u sir
Previous Topic: Validate CSV before Staging Table
Next Topic: help with TRANSLATE function
Goto Forum:
  


Current Time: Wed Dec 07 16:26:38 CST 2016

Total time taken to generate the page: 0.16312 seconds