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

Zheng junxai5 said...

zhengjx20160428
michael kors outlet clearance
oakley sunglasses
longchamp le pliage
kate spade handbags
michael kors outlet online
fitflops
rolex watches
michael kors outlet
tiffany and co
burberry handbags
christian louboutin outlet
christian louboutin sale clearance
ray ban sunglasses outlet
juicy couture
jordan 6s
kobe 8
michael kors outlet
nike blazers shoes
fitflop clearance
jordan 3s
cheap ray ban sunglasses
kate spade purses
tory burch flats
air max
air max 95
kobe 10
concords 11
adidas outlet store
louis vuitton purses
louis vuitton handbags
rolex watches
cheap ray ban sunglasses
louis vuitton bags
nike store
ray ban sunglasses
coach outlet store online
cheap jordans
ralph lauren outlet
giuseppe zanotti outlet

raybanoutlet001 said...

replica watches
ralph lauren uk
fitflops sale
michael kors outlet
polo ralph lauren
michael kors outlet
mbt shoes outlet
cheap ray ban sunglasses
oakley sunglasses
michael kors outlet