Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1615
  • Last Modified:

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

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
0
sikyala
Asked:
sikyala
1 Solution
 
slightwv (䄆 Netminder) Commented:
try:

... exclude=TABLE:\"='INTMETRICS'\" ...

or
... "exclude=TABLE:\"='INTMETRICS'\"" ...
0
 
sikyalaSenior Database AdministratorAuthor Commented:
thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now