Skip to Main Content
Forums

Oracle Database Discussions

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!

export certain rows from table via datapump

user5716448Sep 21 2016 — edited Sep 21 2016

Hi,

Using 11.2.0.3

Have a parfile

DIRECTORY=DATA_PUMP_DIR

DUMPFILE=<file>.dmp

LOGFILE=<file>.log

QUERY=<schema>.<table>:\"WHERE prod_name = 'colthes'\"

want to export only certain rows form a table - fairly small table

when kick off via expdp username/pwd parfile=<parfile>

sitting with message do I need something else in parfile e.g TABLES=<table_name>

                                                                                              SCHEMAS=<schema_owner>

thought query was enough?

Starting "<schema_owner>"."SYS_EXPORT_SCHEMA_01":  jm/******** parfile=por_exp_parfile_bris2

Estimate in progress using BLOCKS method.

Thanks
This post has been answered by Gbenga Ajakaye on Sep 21 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2016
Added on Sep 21 2016
#general-database-discussions
22 comments
11,815 views