Exclude clause with Expdp
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Exclude clause with Expdp

  1. #1
    Join Date
    Oct 2006
    Posts
    175

    Exclude clause with Expdp

    Hello all,
    I've got an issue here. I am exporting an schema with expdp and I want to exclude few tables for the export. Exclude clause lets me use Like operator only once but I need to exclude different types of tables where I'd need to use more than one Like operator. I am on oracle 10gR2, RHEL 3. My expdp command looks something like this:

    expdp DIRECTORY='IMP_DIR' DUMPFILE='Emp.DMP' LOGFILE='Emp.LOG' SCHEMAS=Emp; EXCLUDE=TABLE:\"LIKE \'T1_%\' or LIKE \'T2_%\'\"
    :P it didn't work out.

    Please advice.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool

    See if (maybe) this works:

    EXCLUDE=TABLE:\"LIKE \'T1_%\'\", TABLE:\"LIKE \'T2_%\'\"
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2006
    Posts
    175

    Talking

    Thanks LKBrwn_DBA. It does give me what I wanted with expdp. Thanks again.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Talking

    Maybe you can get rid of the 'escape' characters:

    EXCLUDE=TABLE:"LIKE 'T1_%'", TABLE:"LIKE 'T2_%'"

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Dec 2008
    Posts
    9
    Visit here for more details & examples.
    http://shonythomas.blogspot.com/2011...clude-and.html

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