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: Alan Johns <Alan_at_tarragon.co.uk>
Date: Tue, 12 Jan 1999 10:05:35 +0000
Message-ID: <d7LlqBAv5xm2gAYd@tarragon.co.uk>


Greetings.
There is light at the end of the tunnel for this one. What you seem to want is a method of taking sub-sets of data from multiple tables, extracting it, and then being able to import that data to a target database.

There is a tool called Move for Servers (by Princeton Softech) that allows you to extract relationally intact sub-sets of data to a single compressed file. You can browse this data and use that extract to populate other tables, either in the same or a different database.

The tool also allows you to manipulate the data on insertion, even to the extent of providing date aging capability to date and non date type fields.

If this is of interest, please conntact me at the below address.

In article <77cai4$gt$1_at_nnrp1.dejanews.com>, johan.coussens_at_wang.com writes
>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

Best regards
--
  Alan Johns
  Tarragon Software Ltd - UK & Ireland Distributor for

        Princeton Softech's -   Upgrade 2000
                                Ager 2000
                                Relational Tools for DB2
                                Move for Servers - Oracle
                                Version Merger
        
        ELISE - the MatchMaker. Software for recruitment, estate agencies,      
                                dating agencies, etc from WCC

Phone: 44(0)1480 414141
  Fax: 44(0)1480 436869 Received on Tue Jan 12 1999 - 04:05:35 CST

Original text of this message

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