Re: export data out of Oracle DB

Hi Leslie,

Why not put your criteria into a query and run via SQL*Plus, spooling the output to an operating system file.
You can then "import" this file using SQL*Loader.

Hope this is useful.

Paul.

L. Tseng <lesliet_at_u.washington.edu> wrote in article <5qdigq$bh4_at_nntp6.u.washington.edu>...
> 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
>
Received on Sun Sep 28 1997 - 00:00:00 CDT