impdp Table Constraints
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: impdp Table Constraints

  1. #1
    Join Date
    Oct 2008
    Posts
    4

    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.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote 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

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
  •  


Click Here to Expand Forum to Full Width