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:-)

6 comments:

Ashish said...

Hi,

expdp scott/admin TABLES=emp QUERY=emp:'" WHERE ename='FORD' and emp.sal>5000"' dumpfile=t.dmp

error:

LRM-00101: unknown parameter name 'sal'

Plz give the suggestion

Ashish said...

Hi,

expdp scott/admin TABLES=emp QUERY=emp:'" WHERE ename='FORD' and emp.sal>5000"' dumpfile=t.dmp

error:

LRM-00101: unknown parameter name 'sal'

Plz give the suggestion

Ashish said...

Issue Solved

Ashish said...

I run below query:
expdp 'system/admin' TABLES=scott.EMP query=SCOTT.EMP:\"where SAL\>3000\" DUMPFILE=test8.dmp NOLOGFILE=y

5689 said...

zzzzz2018.8.31
moncler online outlet
pandora
ferragamo shoes
pandora charms outlet
vibram five fingers
adidas football soldes
louboutin shoes
nike factory store
kate spade outlet online
mbt shoes outlet

Unknown said...

balenciaga shoes
vans shoes
calvin klein outlet online
pandora jewelry
louboutin shoes
lebron 16
westbrook shoes
off white jordan 1
adidas tubular
hogan outlet online