Re: How to export parts of a oracle table

Hello,

You could use my Oraxcel utility to do this. You can use Oraxcel to fetch data from Oracle into Excel and to upload that data into a different database.

Please have a look at Oraxcel at

http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker
Developer of Oraxcel, OraSQL, OraCodes and OraWeb http://members.aol.com/gjlinker

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

>Subject: How to export parts of a oracle table
>From: johan.coussens_at_wang.com
>Date: Mon, 11 Jan 1999 07:51:33 GMT
>
>I have to export a Oracle table but not the complete table.
>The table to export contains confidential datam which shouldn't be
>exported. I want to export these tables using the export format so
>I can use the import facility later on to read the data.
>
>Does anyone has an idea how to do this??
>
>The only possibility I see is to make a copy of the original table,
>remove the confidential data, export this copy and cleanup this copy
>afterwards.
>I do not like this solution, because it is slow and requires a lot
>of space (in case of big tables).
>
>Has anyone a better idea???
>
>Thnaks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>------------------- Headers --------------------
>
>Path:
>lobby01.news.aol.com!newstf02.news.aol.com!portc01.blue.aol.com!news-peer
.gip.net!news.gsl.net!gip.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp 1.dejanews.com!not-for-mail
>From: johan.coussens_at_wang.com
>Newsgroups: comp.databases.oracle.misc
>Subject: How to export parts of a oracle table
>Date: Mon, 11 Jan 1999 07:51:33 GMT
>Organization: Deja News - The Leader in Internet Discussion
>Lines: 19
>Message-ID: <77cai4$gt$1_at_nnrp1.dejanews.com>
>NNTP-Posting-Host: 158.67.32.236
>X-Article-Creation-Date: Mon Jan 11 07:51:33 1999 GMT
>X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
>X-Http-Proxy: 1.0 PROXYMUS, 1.0 x9.dejanews.com:80 (Squid/1.1.22) for client
>158.67.32.236
>
Received on Thu Jan 21 1999 - 17:05:02 CST