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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to export part of a table?

Re: How to export part of a table?

From: John Chiu <johnc_at_relsol.com>
Date: Thu, 28 Oct 1999 11:59:46 -0400
Message-ID: <7v9s71$3os$1@newsmaster.pathcom.com>


In oracle 8, You can use partition table to export one or more partitions of the table concerned. However, your data selected is restricted to the organization of the partition.

John Chiu

Burkhard Schultheis wrote in message <38148AF5.A2A074B7_at_tde-online.de>...
>How is it possible to export only a part of a table? I'm using DB2 too,
>and there I can say "export to <file> of <type> <select statement>. Is
>that possible with Oracle tools too? And what about import? DB2 allows
>to import in an existing table, with insert or insert_update. Is this
>possible with Oracle too?
>Thank you in advance!
>--
>Burkhard Schultheis
>Tele Data Electronic
>Wagnerstr. 10
>D-76448 Durmersheim
Received on Thu Oct 28 1999 - 10:59:46 CDT

Original text of this message

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