EXPDP – Smarter in 11gR2

I feel Oracle has made EXPDP utility more smarter by its releases.The below command fails on 10gR2 as “owner” is an unknown parameter for expdp. Correct syntax would be using SCHEMAS parameter in expdp.

[oracle@localhost Desktop]$ expdp directory=DATA_PUMP_DIR dumpfile=full_feb16_scott.dmp logfile=full_feb16.log owner=scott
LRM-00101: unknown parameter name 'owner'

What happens when we try the same on 11gR2 –

D:\scripts>expdp directory=DATA_PUMP_DIR dumpfile=full_feb16_matrix_scott.dmp logfile=full_feb16_matrix.log owner=scott

Export: Release 11.2.0.2.0 - Production on Thu Feb 16 15:51:17 2012

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

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "owner=scott" Location: Command Line, Replaced with: "schemas=scott"
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=full_feb16_matrix_scott.dmp logfile=full_feb16_matrix.log schemas=scott reuse_dumpfiles=true
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."DEPT"                              5.929 KB       4 rows
. . exported "SCOTT"."EMP"                               8.562 KB      14 rows
. . exported "SCOTT"."SALGRADE"                          5.859 KB       5 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  D:\ORACLE\ADMIN\MATRIX\DPDUMP\FULL_FEB16_MATRIX_SCOTT.DMP
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:52:10

export completed successfully 🙂

UPDATE –

Aman Sharma had already written on it long time back and i believe i had missed reading it somehow.For more read http://blog.aristadba.com/?p=164

4 thoughts on “EXPDP – Smarter in 11gR2

  1. Dude the same will work for dumpfile and logfile…
    you can replace dumpfile with file and logfile with log… 😉

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s