| ORA error with object no longer exists [message #230781] |
Thu, 12 April 2007 15:30  |
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 #230907 is a reply to message #230781] |
Fri, 13 April 2007 05:16  |
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>;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
