Data Management

Data Transformations With Oracle Data Pump

Free registration required

Executive Summary

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