1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to exclude tables from export?

Discussion in 'Security, Backup and Recovery' started by kimipatel, Oct 15, 2012.

  1. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    How to exclude some tables from export? We have large database and some of tables are not updated frequently.W e need to export once in month with those tables but in routine we need to export without those tables. Could any one tell me how to do?

    thanks.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You create a list of tables that you DO want to export and pass that to the TABLES command-line parameter. There is no option to exclude tables.
     
    kimipatel likes this.
  3. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    I got it. Thanks for the help.. Thanks a lot...
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    And by using Data pump ypu can do that.
     
    kiran.marla likes this.
  5. Jayalakshmi Subramani

    Jayalakshmi Subramani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Use export import with exclude parameter.

    take a export as scott user except emp and dept tables
    expdp directory=dd1 dumpfile=exs3.dmp logfile=x1.log schemas=scott exclude=table:"in\('DEPT'\,'EMP'\)"
     
  6. jonmax

    jonmax Active Member

    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    65
    Location:
    Dubai UAE
    i am beginner in Oracle filed. it is such a good information for me i got it well.
     
  7. Biswanath Saha

    Biswanath Saha Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Kolkata
    Excluding Tables from a Full Export..
     

    Attached Files: