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);

On Sat, 16 Oct 2010 05:09:02 -0700 (PDT), zigzagdna
<zigzagdna (AT) yahoo (DOT) com> wrote:

Still posting every question to all forums you can spell?

------------
Sybrand Bakker
Senior Oracle DBA

Mr. Baker:

# Still posting every question to all forums you can spell?

As far as I know the costs are the same.

On Oct 16, 8:09*am, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:
After reading Oracle manuals and doing google research, it looks like
one cannot sppecify schema name in exclude table name. If one does,
name of the table is taken as PQM.TABLEA instead of TABLEA being in
PQM schema. It is defintely limitation in expdp exclude and include
syntaxt.


Prem

On Sat, 16 Oct 2010 14:54:07 -0700, John Hurley wrote:

Ah, here we go: st. John in action, protecting the not so intelligent
ones, again.



--
http://mgogala.byethost5.com

On Oct 16, 2:54*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
Well, it depends on who is paying the costs. Since your time is worth
zero, apparently, you may have a skewed view.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...l-and-virtual/