How to flashback table to a previous time point when the table structure was changed?
User request to recovery a table to a previous time point. But when using flashback, it throws error: ORA-01466:
16:22:00 SQL> select * from yksoft.retazu as of timestamp to_timestamp('20130911 13:00:00','yyyymmdd hh24:mi:ss');
select * from yksoft.retazu as of timestamp to_timestamp('20130911 13:00:00','yyyymmdd hh24:mi:ss')
*
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed
Talk with user and find that the table structure was changed at 15:55 by adding a new column to the table. Is there any other efficient way to recovery this table?
0