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 query - ORA-01466: unable to read data - table definition has changed

Lior KerenDec 6 2022

Hello,
When trying to recover deleted table data after a column size has changed - I get
SQL> select * from TABULA.MACDENT$MAC_QFCNSTATUS AS OF TIMESTAMP to_timestamp('2022-12-06 11:30:46', 'YYYY-MM-DD HH24:MI:SS');
select * from TABULA.MACDENT$MAC_QFCNSTATUS AS OF TIMESTAMP to_timestamp('2022-12-06 11:30:46', 'YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed
So - I know table definition has changed, but is there something I can do ?
Thank you

Comments
Post Details
Added on Dec 6 2022
2 comments
1,537 views