Re: sys.npexp$

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 31 Mar 2005 15:33:02 +0200
Message-ID: <d2gu0g$no1$1@news3.zwoll1.ov.home.nl>

knm_dibba wrote:
> for my database, I do not want to export three tables. so I inserted
> the table name, owner and object_type(=2) for the three tables into
> noexp$.
> but during every export the three tables still get exported.
>
> am i missing anything here. do i have to do any other steps. thank you.
>

Yes - you are missing a MAJOR point:
do NOT mess with the data dictionary

As to your "problem": look up the tables= parameter of the EXP command (Utilities Manual). Perhaps add a query against the data dictionary to fill your parameter file quickly

-- 
Regards,
Frank van Bortel

Received on Thu Mar 31 2005 - 07:33:02 CST