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!

expdp with a query condition

MaahjoorOct 11 2017 — edited Oct 16 2017

dear all,

i am using oracle 12c enterprise edition on windows server.

i want to use EXPDP to export scott schema with deptno=10 records only from emp and dept.

i use the folllowing command.

C:\Users\Welcome>expdp system/oracle@pdb schemas=scott directory=TEST_DIR dumpfile=scott.dmp logfile=scott.log query=SCOTT.EMP,SCOTT.DEPT:'"WHERE deptno=10"';

it throw the following error

LRM-00101: unknown parameter name 'deptno'

how can i fix it?

thank you.
This post has been answered by MateuszH on Oct 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2017
Added on Oct 11 2017
#database-upgrade
6 comments
8,686 views