dcsimg
Results 1 to 3 of 3

Thread: datapump import and exclude tables

  1. #1
    Join Date
    Nov 2010
    Posts
    5

    datapump import and exclude tables

    Hi,

    I tried to exclude some tables while importing a datapump dump on solaris.
    so I inserted a column in my parfile:

    EXCLUDE=TABLES:"IN ('P9825B','P9835B','P9843B','P9868B','P9864B')"

    the import started normally and no errors where shown, but the impdp ignored the exclude completely and imported the tables

    can anyone tell me what's wrong whit my exclude ?

    Thanks

    chris

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,909
    Try with TABLE not TABLES

    EXCLUDE=TABLE:"IN ('P9825B','P9835B','P9843B','P9868B','P9864B')"

  3. #3
    Join Date
    Jan 2014
    Posts
    3
    Quote Originally Posted by skhanal View Post
    Try with TABLE not TABLES

    EXCLUDE=TABLE:"IN ('P9825B','P9835B','P9843B','P9868B','P9864B')"


    Check out this site - http://www.oraclesql-plsql.com for Oracle database,sqlplus and plsql related articles.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •