Re: Exporting part of a Oracle table

Maybe my Oraxcel utility is something for you. With Oraxcel you can fetch you non confidential data into Excel. Later you can upload that data into another Oracle database.

Have a look at Oraxcel at

http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker

In article <77ct72$fue$1_at_nnrp1.dejanews.com>, johan.coussens_at_wang.com writes:

>Subject: Exporting part of a Oracle table
>From: johan.coussens_at_wang.com
>Date: Mon, 11 Jan 1999 13:09:54 GMT
>
>I have some oracle tables with confidential data in them. I need to export
>them on a regularly basis but WITHOUT the confidential data in it. The export
>utility of Oracle only allows to export the complete table. No conditions are
>possible. I want to use the export file format, which will allows me later to
>import the data using the imp facility of Oracle.
>
>Does anyone has an idea how I can set up such kind of export facility???
>
>Important to know. The tables I have to export are rather big. The possible
>solution to copy the table and removing the confidential data before
>exporting this copy is not really feasible (because of the speed and memory
>consumption).
>
>Has any Oracle guru a good idea???
>
>Thanks
Received on Fri Jan 22 1999 - 16:19:43 CST