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: export data out of Oracle DB

Re: export data out of Oracle DB

From: Jeremy Cope <jeremy_at_intrahealth.co.nz>
Date: 1997/07/15
Message-ID: <33CAF225.607E53FB@intrahealth.co.nz>#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

  one way would be to create a temp table 'create table temp as select * from sourcetable where timestamp = x' to contain just the rows you want to export and then export this table.

Regards
Jeremy Cope
IntraHealth Systems Limited
Auckland NZ Received on Tue Jul 15 1997 - 00:00:00 CDT

Original text of this message

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