Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump expdp query parameter

Mike301Oct 13 2015 — edited Oct 15 2015

Friends,

DB: 11gR2

OS: Linux

I'm trying to export schema with below conditions inside one export parameter file:

1. Export entire schema

2. From the schema two tables only export one month of data

3. Exclude statistics

Running export with

expdp system/pwd parfile=exp_user1.par

I tried using below parameter file but it doesn't find any data:

(ora-31655 : no data or metadata objects selected for job)

Parameter file: (exp_user1.par)

DIRECTORY=DATA_PUMP_REFRESH
DUMPFILE=dump_01.dmp
LOGFILE=dump_01.log
SCHEMAS=USER1
CONTENT=ALL
EXCLUDE=STATISTICS
QUERY=user1.employees: "where date_dt >= 20150101 and date_dt <= 20150130"
QUERY=user1.managers: "where date_dt >= 20150101 and date_dt <= 20150130"

Is there any changes required in above or this is not possible?

Thanks.

Message was edited by: 977272 1. Added schemas=user1 2. Added expdp running with system user

This post has been answered by JuanM on Oct 15 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2015

Added on Oct 13 2015

#database-key-features, #export-import-sql-loader-external-tables

10 comments

3,605 views