Database Backup and Recovery (MOSC)

MOSC Banner

How to flashback table to a previous time point when the table structure was changed?

edited Sep 12, 2013 7:49PM in Database Backup and Recovery (MOSC) 9 commentsAnswered
 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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center