DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

Data Pump and export Parameter-Parfile



Data Pump and export Parameters-Parfile

Data Pump Parameters-Parfile

expdp scott/tiger parfile=/u01/sam.par


Step:1

[oracle@oracle11g u01]$ vi sam.par
[oracle@oracle11g u01]$ cat sam.par

tables=emp dumpfile=emp1.dmp logfile=emp1.log directory=TEST_DIR

Step:2

[oracle@oracle11g u01]$ expdp scott/tiger parfile=/u01/sam.par

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 11:33:00 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** parfile=/u01/sam.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                               8.570 KB      14 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  /u01/dump/emp1.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 11:33:15


export Parameters-Parfile


exp scott/tiger parfile=/u01/sam.par


Step:1

[oracle@oracle11g u01]$ vi sam.par
[oracle@oracle11g u01]$ cat sam.par
tables=emp file=/u01/emp1.dmp log=/u01/emp1.log


Step:2

[oracle@oracle11g u01]$ exp scott/tiger parfile=/u01/sam.par

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 11:30:36 2015

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


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.


No comments: