Re: How to export part of a table?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 28 Oct 1999 18:20:54 +0800
Message-ID: <38182386.54CF@yahoo.com>

John Chiu wrote:
>
> 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

8i supports a where clause as well.
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Oct 28 1999 - 05:20:54 CDT