The table could be restored to using flashback table option. Before attempting it, find out how far to flash the table.
Steps :-
1. sql> select count(*) from scott.emp;
2. export of the table
3. flashback table
sql> alter table scott.emp enable row movement;
sql> flashback table scott.emp to timestamp
to_timestamp('2010-12-18 12:00:00','YYYY-MM-DD HH24:MI:SS');
Flashback complete.
4. sql> select count(*) from scott.emp;
COUNT(*)
----------
784871
5. confirm with apps team
Hope this helps! Regards Rupam
