Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sys.npexp$

Re: sys.npexp$

From: Noel <tbal_at_go2.pll-l>
Date: Fri, 01 Apr 2005 10:35:57 +0200
Message-ID: <d2j164$iod$1@inews.gazeta.pl>


User knm_dibba wrote:

> thanks for the replies.
> the export is done using a script which cannot be changed. the script
> is rolled out in all databases and has to be same. so I cannot change
> the FULL=Y with TABLES=(thousands of tables names).
> I understand all the replies as I knew you what u say WELL before.
> using TABLES= is not a option for me. If that is the only option as per
> you, pls do not reply.
> and if this is the only option I already know it.

Well, there is other option, instead of write own export or mess with dump file.
You can use policy system of Oracle.
There is possibility to enable policies on that tables to force export program, runed by specified user, select no rows from that tables.

-- 
Noel
Received on Fri Apr 01 2005 - 02:35:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US