Saturday, September 24, 2011

PARFILE parameter in datapump


The PARFILE(parameter file) is opened and read by the client running the expdp image. All parameters are set in this file.

Demo: -

Create a parfile below as scott1.par and perform the export.

SCHEMAS=SCOTT
DUMPFILE=exscott.dmp
LOGFILE=expsdd.log


SQL> host expdp system/sys parfile=D:\scott1.par.txt

Export: Release 11.2.0.1.0 - Production on Sat Sep 24 10:46:11 2011

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
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_03":  system/******** parfile=D:\scc.par.txt
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 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
.....

Enjoy:-)