Re: export data out of Oracle DB
From: Vitaly Sikolenko <vsikolen_at_ru.oracle.com>
Date: 1997/07/25
Message-ID: <33D863DE.AF45210A_at_ru.oracle.com>#1/1
Date: 1997/07/25
Message-ID: <33D863DE.AF45210A_at_ru.oracle.com>#1/1
L. Tseng wrote:
> Hi,
>
> Does anyone know if there is a utility that can export/import data
> from/to a table
> using some criteria like in a where clause? Oracle's export/import
> utility can only
> export/import ALL the data from/to a table and they don't work with a
> view.
> For example I want to export part of a 10000 row table basing on a
> timestamp colume,
> how can this be done?
>
> Thanks,
>
> Leslie
I'm afraid there is no the standard tool under Oracle7: you are to
make something
of your own (for example using SQL*Plus and SQL*Loader). At Oracle8 you
might be able to export/import table partitions.
-- Vitaly Sikolenko Senior Sales Consultant Server & Gateways ORACLE C.I.S. Moscow Russia E-mail: vsikolen_at_ru.oracle.com The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.Received on Fri Jul 25 1997 - 00:00:00 CEST