Hi experts,
I use version 17.1.717.3711.
I'm trying to explore the feature of the DATA PUMP parameter REMAP_DATA, and I've made it work finally.
However, I'd like to double-check with you to see if there's anything I might be missing or can improve.
Purpose:
I want to export data from schema HR999, and import it into a new schema HR12345,
but with one modification: the salary column values in the employees table should be multiplied by 0.01 during the import process.
Here’s what I did:
1.Used SYS to create the user HR12345.
2.Logged in as HR12345 and created a package called remap_pkg which includes the remap_salary_func function that multiplies salary by 0.01.
3.Exported the HR999 schema using Data Pump.
4.Performed the import (as HR999) with the following REMAP_DATA parameter:
hr999.employees.salary:hr12345.remap_pkg.remap_salary_func
5.Verified that the salary values in HR12345.employees were successfully updated to 1% of the original.
Now I have a few questions:
Q1. During the import, I got this message:ORA-31684: Object type USER:"HR12345" already exists.
The import still completed successfully, but is there any way to avoid this warning?
Q2. This is my first time using the REMAP_DATA parameter and I followed Oracle's documentation.
Based on the steps above, is there anything I could do better or more efficiently?
Q3. I noticed that Data Pump Export in Toad also has a "Remap Functions" field.
Does REMAP_DATA also work during export, or is it import-only?