HarekrushnaPanigrahy
asked on
Data Purging and Restoration
Hi Experts,
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..
Regards,
harekrushna.
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..
Regards,
harekrushna.
Hi, just wondered if you had managed to resolve your purge and restoration issue.
ASKER
can u give some idea about REMAP_SCHEMA options how it works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure from your description exactly what you are doing, a fuller explanation would be useful.
As far as using oracle datadump to load from a dmp file into a table with a different definition this can't be done. To get around this you will need to import the data from the dmp file into a schema where the table doesn't already exists. You will need to use the REMAP_SCHEMA option to import the table to a schema that is different to the one from which it was originally exported.
You will then need to write a specific insert select statement to insert the required rows into the destination table (the one that was original exported, but which now has different columns). The imported table can then be dropped.