Data Purging and Restoration
Posted on 2008-01-31
I have an application which schedules the purging activity. and purges the set of tables at run time(tables to be purged gets at run time).
It creates an external table using oracle datapump. after deleting the records drops the external table and the same name is used for diff tables. Now i have the *.dmp which contains the purged data. now i want to restore the data from those dumps.? mean while the table structure has been changed ... some col s added and some droped...
plz suggest an purge and restoration approach..