Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to export parts of a oracle table
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