Tuesday, January 29, 2013

Oracle Data Pump

Today I'm going to show how I use Oracle Data Pump utilities. Starting with Oracle 10gR1, Oracle replaced both the export and import utilities by their new Data Pump counterpart : expdp and impdp respectively. The official documentation on these utilities is found in the Oracle Database Utilities10g Release 2 (10.2)

The steps outlined in this blog post are part of a database consolidation effort in which several databases from two different machines will be merged into a new Linux x86_64 server running RedHat Enterprise Linux 5.9 and Oracle RDBMS 10gR2.