Diff Bet Exp And Expdp.docx

DIFFERENCE BETWEEN EXP AND EXPDP UTILITIES ########################################################################################## ## ############################################################################# ###

EXP UTILITY ############################################################################# ### [WILSHIRE@dba15 dpump]$ time exp file=full.dmp log=full.log full=y

Export: Release 11.2.0.1.0 - Production on Thu Jan 13 14:55:19 2011 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.1.0 Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in US7ASCII character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions . exporting system procedural objects and actions . exporting pre-schema procedural objects and actions . exporting cluster definitions . about to export SCOTT's tables via Conventional Path ... . . exporting table DEPT 4 . . exporting table DUMMY 1 . . exporting table EMP 91750400 . . exporting table EMP1 458752 . . exporting table SALGRADE 5 . about to export U1's tables via Conventional Path ... . . exporting table DEPT 4 . . exporting table DUMMY 1

rows rows rows rows rows

exported exported exported exported exported

rows exported rows exported

. . exporting table EMP 53127054 . . exporting table SALGRADE 5 . about to export PHANI's tables via Conventional Path ... . . exporting table DEPT 4 . . exporting table DUMMY 1 . . exporting table EMP 14 . . exporting table SALGRADE 5 . about to export TTS's tables via Conventional Path ... . . exporting table DEPT 4 . . exporting table DUMMY 1 . . exporting table EMP 14 . . exporting table SALGRADE 5 . about to export U2's tables via Conventional Path ... . . exporting table EMP 91750400 . . exporting table T 1 . about to export U3's tables via Conventional Path ... . . exporting table EMP 91750400 . about to export TS_16K's tables via Conventional Path ... . . exporting table EMP 53127053 . exporting synonyms . exporting views . exporting referential integrity constraints . exporting stored procedures . exporting operators . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting triggers . exporting materialized views . exporting snapshot logs Export terminated successfully without warnings.

rows exported rows exported rows rows rows rows

exported exported exported exported

rows rows rows rows

exported exported exported exported

rows exported rows exported rows exported rows exported

################################################## # TIME ELAPSED : 42m13s # ################################################## ############################################################################# ###

EXPDP UTILITY ############################################################################# ### [WILSHIRE@dba15 dpump]$ time expdp directory=dpump dumpfile=full.dmp log=full.log full=y

Export: Release 11.2.0.1.0 - Production on Tue Jan 18 12:01:14 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. Username: / as sysdba

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: "log=full.log" Location: Command Line, Replaced with: "logfile=full.log" Legacy Mode has set reuse_dumpfiles=true parameter. Starting "SYS"."SYS_EXPORT_FULL_01": /******** AS SYSDBA directory=dpump dumpfile=full.dmp logfile=full.log full=y reuse_dumpfiles=true Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Total estimation using BLOCKS method: 20.00 GB Processing object type DATABASE_EXPORT/TABLESPACE Processing object type DATABASE_EXPORT/PROFILE Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/CONTEXT Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC Processing object type . . exported "U1"."EMP" 2.154 GB 53127054 rows . . exported "U2"."EMP" 3.721 GB 91750400 rows . . exported "U3"."EMP" 3.721 GB 91750400 rows . . exported "SCOTT"."EMP" 3.721 GB 91750400 rows . . exported "TS_16K"."EMP" 2.154 GB 53127053 rows . . exported "SCOTT"."EMP1" 18.16 MB 458752 rows . . exported "PHANI"."DEPT" 5.929 KB 4 rows . . exported "PHANI"."DUMMY" 5.007 KB 1 rows . . exported "PHANI"."EMP" 8.562 KB 14 rows . . exported "PHANI"."SALGRADE" 5.867 KB 5 rows . . exported "SCOTT"."DEPT" 5.929 KB 4 rows . . exported "SCOTT"."DUMMY" 5.007 KB 1 rows . . exported "SCOTT"."SALGRADE" 5.867 KB 5 rows . . exported "TTS"."DEPT" 5.929 KB 4 rows . . exported "TTS"."DUMMY" 5.007 KB 1 rows . . exported "TTS"."EMP" 8.562 KB 14 rows . . exported "TTS"."SALGRADE" 5.859 KB 5 rows . . exported "U1"."DEPT" 5.929 KB 4 rows

. . exported "U1"."DUMMY" 5.007 KB 1 rows . . exported "U1"."SALGRADE" 5.859 KB 5 rows . . exported "U2"."T" 5.398 KB 1 rows . . exported "TTS"."BONUS" 0 KB 0 rows . . exported "U1"."BONUS" 0 KB 0 rows Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ***************************************************************************** * Dump file set for SYS.SYS_EXPORT_FULL_01 is: /disk1/oradata/prod/dpump/full.dmp Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 12:12:40

################################################## # TIME ELAPSED : 11m31s # ##################################################

OBSERVATION : TIME TAKEN FOR BACKUP DATABASE USING EXP AND EXPDP UTILITIES EXP UTILITY

:

42m 13s

EXPDP UTILITY

:

11m 31s

DIFFERENCE

:

30m 42S

TIP : EXPDP UTILITY FOR HUGE DATABASE BACKUPS IS MORE PREFFERABLE COMPARED TO EXP UTILITY.