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.
[[email protected] 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”
Dude the same will work for dumpfile and logfile…
you can replace dumpfile with file and logfile with log… 😉
Yes true..thats why its called Legacy mode. Aman’s Blog is in more detail 🙂
That’s called Legacy mode and I blogged about it here,
http://blog.aristadba.com/?p=164
🙂
Seems i had missed reading it 😉 Updated blog with your blog link 🙂