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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to export parts of a oracle table

Re: How to export parts of a oracle table

From: Ed Bruce <Ed.Bruce_at_ha.hac.com>
Date: Mon, 11 Jan 1999 13:05:03 -0600
Message-ID: <369A4B5F.DC851E00@ha.hac.com>


johan.coussens_at_wang.com wrote:
>
> 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.

Split your main table into two tables. One with the confidential data and the other with the rest. Create a view that joins the two tables and use that for you normal activity. Then just export and import the non-confidential data.

later,
Ed Bruce Received on Mon Jan 11 1999 - 13:05:03 CST

Original text of this message

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