How to export parts of a oracle table

From: <johan.coussens_at_wang.com>
Date: Mon, 11 Jan 1999 07:51:33 GMT
Message-ID: <77cai4$gt$1@nnrp1.dejanews.com>

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 Received on Mon Jan 11 1999 - 01:51:33 CST