DataPump Legacy Mode in 11g Release 2

If you’re planning a migration to 11g, then one of the many items on your “to do” list, will be to check whether or not any database management scripts that you currently use will need to be re-written.

If you’re using Oracle 9i Release 2 or earlier, then you’ll be using scripts for the export and import utilities.  Whilst many of the parameters used by these tools have equivalent parameters when using datapump, a useful feature in 11g Release 2 is the legacy mode feature.

With this new feature, you can simply use your existing export/import scripts with the datapump impdp/expdp utilities.  Datapump won’t re-write the scripts for you, but it will transform the parameters as the script runs, so that datapump completes successfully.  At a later stage, you can then re-write your export/import scripts, without having to manually check what changes should be made.

To demonstrate this functionality, we can take a quick norows export of an 11g Release 2 database.  We’ll use the parameters “file”,”log”,”buffer” and “rows” which are export parameters, but aren’t listed as being parameter for use with expdp.

export ORACLE_SID=orcl
export ORACLE_HOME=/u01/opt/oracle/product/11gR2/db_1
expdp system/password file=test_full.dmp log=test_full.log buffer=1048576 rows=n

An extract from the logfile contains the following lines:-

Export: Release 11.2.0.1.0 - Production on Fri Oct 23 22:26:42 2009
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: “buffer=1048576″ Location: Command Line, ignored.
Legacy Mode Parameter: “file=test_full.dmp” Location: Command Line, Replaced with: “dumpfile=test_full.dmp”
Legacy Mode Parameter: “log=test_full.log” Location: Command Line, Replaced with: “logfile=test_full.log”
Legacy Mode Parameter: “rows=FALSE” Location: Command Line, Replaced with: “content=metadata_only”
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_01″:  system/******** dumpfile=test_full.dmp logfile=test_full.log content=metadata_only reuse_dumpfiles=true
Processing object type SCHEMA_EXPORT/USER

Master table “SYSTEM”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
  /u01/opt/oracle/admin/orcl/dpdump/test_full.dmp
Job “SYSTEM”.”SYS_EXPORT_SCHEMA_01″ successfully completed at 22:27:59

 

You’ll notice that datapump converts the export-specific parameters to their datapump equivalents on the fly and then completes the export as normal. The other point to notice about the export, is that the dumpfile and logfile will have been created in the default datapump directory, rather than in the location that you ran the commands from - as would have been the case with the export utility.   (select directory_path from dba_directories where directory_name=’DATA_PUMP_DIR’; - to confirm where this location is in your environment).

 

The same legacy mode has also been implemented for the impdp datapump utility. Below is an extract from the logfile for a quick table import, which was run with the parameters “file”,”log”,”buffer”,”ignore” and “commit” from the import utility.
impdp system/password file=table_export.dmp log=table_import.log buffer=1048576 ignore=y commit=y

Import: Release 11.2.0.1.0 - Production on Fri Oct 23 22:44:48 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: “buffer=1048576″ Location: Command Line, ignored.
Legacy Mode Parameter: “commit=TRUE” Location: Command Line, ignored.
Legacy Mode Parameter: “file=table_export.dmp” Location: Command Line, Replaced with: “dumpfile=table_export.dmp”
Legacy Mode Parameter: “ignore=TRUE” Location: Command Line, Replaced with: “table_exists_action=append”
Legacy Mode Parameter: “log=table_import.log” Location: Command Line, Replaced with: “logfile=table_import.log”
Master table “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “SYSTEM”.”SYS_IMPORT_FULL_01″:  system/******** dumpfile=table_export.dmp logfile=table_import.log table_exists_action=append
Processing object type SCHEMA_EXPORT/USER

. . imported “TEST”.”T1″                                5.156 KB      17 rows
Job “SYSTEM”.”SYS_IMPORT_FULL_01″ completed …

References:

1) Oracle 9i Database Utilities Release 2 (9.2)
2) Oracle Database Utilities 10g Release 2 (10.2)
3) Oracle Database Utilities 11g Release 2 (11.2)

One Response to “DataPump Legacy Mode in 11g Release 2”

  1. DataPump Legacy Mode in 11g Release 2 | Canning IT LTD Says:

    […] DataPump Legacy Mode in 11g Release 2 […]

Leave a Reply

You must be logged in to post a comment.


Xanax Online Buy Online Xanax Buy Vicodin Effexor Buy Phentermine Buy Adderall Buy Cialis Buy Ultram Buy Codeine Glucophage Buy Acyclovir Buy Paxil Buy Alprazolam Buy Alprazolam Buy Paxil Buy Lipitor Buy Cheap Phentermine Buy Zyrtec Buy Didrex Ultracet Xanax On Line Codeine Bontril Buy Generic Viagra Viagra Diflucan Lipitor Bontril Ultracet Buy Seroquel Buy Hydrocodone Buy Ativan Buy Nexium Buy Phentermine Buy Celexa Buy Generic Viagra Buy Effexor Ativan Buy Darvocet Zyprexa Buy Valium Online Buy Levitra Biaxin Buy Norco Buy Flexeril Carisoprodol Buy Lortab Alprazolam Phentermine Buy Hydrocodone Online Buy Ambien Celexa Buy Zithromax Buy Xanax Online Bupropion Buy Glucophage Alprazolam Ambien Buy Adipex Online Xanax Viagra Online Bontril Buy Celexa Buy Norvasc Buy Adderall Buy Vicodin Buy Didrex Buy Diazepam Norco Buy Xanax Online Levitra Glucophage Buy Line Xanax Buy Levitra Buy Fioricet Norco Buy Bupropion Buy Tramadol Buy Lorazepam Tramadol Online Buy Butalbital