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!

Flashback error / ORA-01466 : Unable to read data -table definitions has ch

779542Feb 22 2012 — edited May 3 2012
hi,

i am facing a problem with flashback querry.

scenario :
i deleted data from emp table .
after that i altered table by modifying one column from NUMBER(2) to VARCHAR2(2).
after altering the table when i try to see the data by using flashback query it is throwing error.

select * from room_master as of timestamp(sysdate-2);

select * from room_master as of scn 681559032;

select * from flashback_transaction_query
where table_name = 'EMP'

Error message : ORA-01466 : Unable to read data -table definitions has changed

please advice me to sort out the issue.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2012
Added on Feb 22 2012
7 comments
29,786 views