Download Now Free registration required
Database Administrators (DBAs) sometimes need to modify the data being exported out of a database or imported into a database. For example, as part of an export a DBA may need to scrub sensitive data such as credit card numbers or social security numbers. Similarly, during an import, the DBA may want to convert internal identification numbers in a table to avoid collisions with existing data. Previously, doing these sorts of conversions required many additional steps to stage the data prior to modification. With Oracle Database 11g, there is a new parameter, REMAP_DATA, for the expdp and impdp commands that helps to automate this process. The REMAP_DATA parameter allows a user-supplied PL/SQL function to modify user data as Data Pump transfers the data.
- Format: PDF
- Size: 154.3 KB