-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|