Solved

impdp

Posted on 2011-03-02
3
433 Views
Last Modified: 2012-05-11
Do you have an actual example of an impdp with exclude tables without creating a parameter file?
0
Comment
Question by:msimons4
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 35017747
The docs:
http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/dp_import.htm#i1007865

everything that can be in a parameter file can also be specified on the command line.
0
 

Author Comment

by:msimons4
ID: 35018243
This worked:

EXCLUDE=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”

0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35018827
Glad you found a workable solution.  Don't forget to close the question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now