Oracle DataPump 4 – Export database using EXPDP command

Once the directory access is granted, the user scott can export his database objects with command arguments. Open command prompt (CMD) and enter the expdp command with parameters

EXPDP Command Format

expdp <username>/<password>@<database_name> directory=<directory_name> dumpfile=<dump_file_name> logfile=<log_file_name>

or

D:\> expdp scott/tiger@xe directory=TEST_DIR dumpfile=DB11G.dmp logfile=expdpDB11G.log

Example

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

H:\>expdp scott/tiger@xe directory=TEST_DIR dumpfile=DB11G.dmp logfile=expdpDB11G.log

Export: Release 11.2.0.2.0 – Production on Mon Aug 5 13:49:36 2013

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

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 – Productio
n
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/********@xe directory=TEST_DIR d
umpfile=DB11G.dmp logfile=expdpDB11G.log

Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
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/COMMENT
. . exported "SCOTT"."EMP"                               5.875 KB       2 rows
. . exported "SCOTT"."STUDENT"                           5.882 KB       2 rows
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
  D:\A5518\ZZZ\DB11G.DMP
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 13:49:40

H:\>


 

You can leave a response, or trackback from your own site.

Leave a Reply