Exclude syntax in expdp for a table
From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sat, 16 Oct 2010 05:09:02 -0700 (PDT)
Message-ID: <e661115b-ce3c-47e8-bbf2-6068b657f188_at_l20g2000yqm.googlegroups.com>
I am using Oracle 11.1.0.7.x on HP UNIX 11i. I am doing full expdp and want to exclude certain tables.
Expdp full=Y parfile=expdp.par
I am using following syntax is an expdp.par EXCLUDE=TABLE:"IN ('PQM.COMPLAINT_LTR_ORIG')" Where PQM is my schema. My database has many schemas I want to exclude Table in a specific schema.
I am finding that expdp is not excluding this table. However, If I remove PQM,
EXCLUDE=TABLE:"IN ('COMPLAINT_LTR_ORIG')" Table is excluded. Problem I have is table same name exists in other schemas as well
So many tables get excluded which is not what I want. How can I exclude table in a specific schema while doing full export data pump. (full=Y); Received on Sat Oct 16 2010 - 07:09:02 CDT
Date: Sat, 16 Oct 2010 05:09:02 -0700 (PDT)
Message-ID: <e661115b-ce3c-47e8-bbf2-6068b657f188_at_l20g2000yqm.googlegroups.com>
I am using Oracle 11.1.0.7.x on HP UNIX 11i. I am doing full expdp and want to exclude certain tables.
Expdp full=Y parfile=expdp.par
I am using following syntax is an expdp.par EXCLUDE=TABLE:"IN ('PQM.COMPLAINT_LTR_ORIG')" Where PQM is my schema. My database has many schemas I want to exclude Table in a specific schema.
I am finding that expdp is not excluding this table. However, If I remove PQM,
EXCLUDE=TABLE:"IN ('COMPLAINT_LTR_ORIG')" Table is excluded. Problem I have is table same name exists in other schemas as well
So many tables get excluded which is not what I want. How can I exclude table in a specific schema while doing full export data pump. (full=Y); Received on Sat Oct 16 2010 - 07:09:02 CDT