DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: expdp (exclude clause)

Hybrid View

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    expdp (exclude clause)

    can somebody tell me why my exlcude clause is not working?

    Based on my parfile, I would not have expected to see the table paultest1
    being exported. But yet the log below shows differently.

    Note: Both these tables are partitioned with 2 paritions and I am running
    oracle 11.1.0.7

    This is how I invoked the expdp:

    nohup expdp / parfile=c0harpa.exp.par &


    contents of my parfile

    $ cat c0harpa.exp.par
    directory=c0harpa_pump_dir
    dumpfile=c0harpa.dmp
    logfile=c0harpa_exp.log
    SCHEMAS=c0harpa
    exclude=TABLE:"='c0harpa.paultest1'"

    contents of my expdp log. Notice data for paultest1 is present in the log.
    I would have thought this would not be there. The zero rows for the two
    partitions are correct since there is no data for those rows.

    $ cat c0harpa_exp.log
    ;;;
    Export: Release 11.1.0.7.0 - 64bit Production on Saturday, 19 February, 2011 12:25:43

    Copyright (c) 2003, 2007, Oracle. All rights reserved.
    ;;;
    Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    FLASHBACK automatically enabled to preserve database integrity.
    Starting "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01": /******** parfile=c0harpa.exp.par
    Estimate in progress using BLOCKS method...
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    Total estimation using BLOCKS method: 800 MB
    Processing object type SCHEMA_EXPORT/USER
    Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
    Processing object type SCHEMA_EXPORT/ROLE_GRANT
    Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
    Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
    Processing object type SCHEMA_EXPORT/TABLE/TABLE
    . . exported "C0HARPA"."PAULTEST":"SYS_P61" 170.6 MB 10000000 rows
    . . exported "C0HARPA"."PAULTEST1":"SYS_P63" 170.6 MB 10000000 rows
    . . exported "C0HARPA"."PAULTEST":"SYS_P62" 0 KB 0 rows
    . . exported "C0HARPA"."PAULTEST1":"SYS_P64" 0 KB 0 rows
    Master table "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
    ******************************************************************************
    Dump file set for OPS$ORACLE.SYS_EXPORT_SCHEMA_01 is:
    /backup/c0harpa/c0harpa.dmp
    Job "OPS$ORACLE"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:27:13

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

    Cool

    Can't check it out now, but you need to change this:
    Code:
    exclude=TABLE:"='PAULTEST1'"
    -- or this --
    exclude=TABLE:"='C0HARPA.PAULTEST1'"
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    LK,

    Thanks for the advice, this appears to work:

    exclude=TABLE:"='PAULTEST1'"

    Note the table name is uppper case compared to my example, which was
    lower case.

    If I prefernce the table, with the schema owner this does not work:

    exclude=TABLE:"='C0HARPA.PAULTEST1'"


    Would this be because I specified the schemas in the parfile? If not, I
    would consider this to be a bug. What would happen if I have two tables
    with the same name but with different schema owners.

    Thanks again

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