<div>
<div class="content wysiwyg-content">
When I try to exclude one or more tables in my schema export I get an LRM error<br />
<br />
expdp system/***** schemas=acct_mgr exclude=TABLE:&quot;='INTMETRIC<wbr />S'&quot; DIRECTORY=dpump_dir1 dumpfile=acct_mgr_140814.d<wbr />mp logfile=acct_mgr_140814.lo<wbr />g<br />
LRM-00116: syntax error at 'TABLE:' following '='<br />
<br />
When I try it again using the escape I still get an error as well<br />
<br />
expdp system/***** schemas=acct_mgr exclude=TABLE:\&quot;=\'INTMETR<wbr />ICS\'\&quot; DIRECTORY=dpump_dir1 dumpfile=acct_mgr_140814.d<wbr />mp logfile=acct_mgr_140814.lo<wbr />g
</div>
</div>


When I try to exclude one or more tables in my schema export I get an LRM error

expdp system/***** schemas=acct_mgr exclude=TABLE:"='INTMETRICS'" DIRECTORY=dpump_dir1 dumpfile=acct_mgr_140814.dmp logfile=acct_mgr_140814.log
LRM-00116: syntax error at 'TABLE:' following '='

When I try it again using the escape I still get an error as well

expdp system/***** schemas=acct_mgr exclude=TABLE:\"=\'INTMETRICS\'\" DIRECTORY=dpump_dir1 dumpfile=acct_mgr_140814.dmp logfile=acct_mgr_140814.log

how do I export using datapump to export schema excluding certain tables

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.