Re: Exclude syntax in expdp for a table
Date: Sat, 16 Oct 2010 18:44:21 +0200
Message-ID: <ohljb6l8gtes1hmpub54scgsblj2pb30t4_at_4ax.com>
On Sat, 16 Oct 2010 05:09:02 -0700 (PDT), zigzagdna <zigzagdna_at_yahoo.com> wrote:
>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);
Still posting every question to all forums you can spell?
Sybrand Bakker
Senior Oracle DBA Received on Sat Oct 16 2010 - 11:44:21 CDT