-
impdp Table Constraints
I am using a Oracle 10.2.0.3.0 Enterprise on Centos 4.6.
I am trying to backup a small subset of data with impdp over a network link. I want to limit the schemas to a list and the tables to the results of a query. I've been using the following PARFILE:
SCHEMAS=SCHEMA1,SCHEMA2,CompleteListOfSchemas
INCLUDE=TABLE:"IN (SELECT TabName FROM ADMIN.BACKUP_TABLES)"
NOLOGFILE=N
NETWORK_LINK=link_to_source_db
TABLE_EXISTS_ACTION=SKIP
However, when I run this, it works for about 14 hours(there is a lot of data) and then I get:
ORA-39165: Schema SCHEMA1 was not found.
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
The import is being run on the destination machine and attempting to import over the network from the source machine.
Is my PARFILE incorrect?
Thanks.
-
I am trying to backup a small subset of data with impdp over a network link.You can't use impdp to backup, use expdp.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
I am trying to backup a small subset of data with impdp over a network link.
You can't use impdp to backup, use expdp.
Thanks,
if you are going to write crap, think about it first - you obviously have no idea what impdp can do over a network
-
Sorry guys, I mis-read the question.
Thanks for letting me know Dave. Here after I will read the question couple of times before I reply.
Bye the way, do you have any solution?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|