Re: export with conditions

From: <hohbeje_at_my-deja.com>
Date: Mon, 29 Nov 1999 15:08:11 GMT
Message-ID: <81u4so$jm9$1@nnrp1.deja.com>

"Kathinka Diehl" <kathinka_at_rrr.de> wrote:
> I have to export a part of a table.
> This table has more then 60.000.000 rows
> and I need just for example the last 10.000 rows.
>

I'm using Oracle8i R8.1.5, You can try to find when this was implemented.

There is an Export Parameter "QUERY" example: exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\<160\"

or using parameter file:
exp user/passw PARFILE=Export_query.txt where Export_query.txt contains:
query="where job='SALESMAN' and sal<1600" ... and other parameters

Hohbeje B.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 29 1999 - 09:08:11 CST