Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01466 unable to read data table definition has changed oracle.

890271Oct 24 2011 — edited Oct 24 2011
hi all,

i truncated a table before 10 min. now i want the data's so i used this query ;

select *
from ( select *
from sometable where some_condition )
as of timestamp sysdate-1;


but it shows:

""" ora-01466 unable to read data table definition has changed oracle"""";

how to get the deleted records from database????????????

Edited by: 887268 on Oct 24, 2011 4:02 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2011
Added on Oct 24 2011
8 comments
2,469 views