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!

exclude tables in datapump export

user097815Dec 17 2009 — edited Dec 17 2009

I am trying to a full schema level export using datapump but want to exclude some tables...and i found the below from oracle-base.com site
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

expdp scott/tiger@db10g schemas=SCOTT exclude=TABLE:"= 'BONUS'" directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

but when i try to test it out....it throws me an error
LRM-00116: syntax error at 'TABLE:' following '='

what is the right cmd for doing a full schema level export and exclude couple of tables that i do not needed...using expdp

sorry forgot to mention i am on 10.2.0.3 on HP

Edited by: S2K on Dec 17, 2009 8:11 AM

This post has been answered by 591186 on Dec 17 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2010

Added on Dec 17 2009

#general-database-discussions

16 comments

32,867 views