Re: Particular Export and Import - export possible after 8.1.5
Date: Tue, 11 Apr 2000 10:06:32 -0400
Message-ID: <8cvbf9$bvu$1_at_bob.news.rcn.net>
... Also If your using Oracle older than 8.1.x with no QUERY option available in exp utility you could create a temporary (intermediate) table as a row subset from original table by CREATE TABLE AS SELECT <your query>... and then export that table containing of needed records.
Good luck,
Eugene.
Hans Henrik Krohn <hhk_at_tips.dk> wrote in message
news:8cv6qb$me7$1_at_news1.tele.dk...
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> skrev i en
> nyhedsmeddelelse:955397880.13269.0.pluto.d4ee154e_at_news.demon.nl...
> > Answers below embedded
> > Riccardo D.S. <rdistefano_at_aleniasystems.finmeccanica.it> schreef in
> > berichtnieuws 38F1D117.A2F70A54_at_aleniasystems.finmeccanica.it...
> > > Is it possible to Export, from a Table into a ".dmp" file, the only
> record
> > that
> > > satisfied
> > > e particular condition?
> > >
> >
> > No
> >
>
> Actually yes, as of Oracle 8.1.5 it is possible to export selected rows
from
> a table using the QUERY parameter. Example:
> exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\<1600\"
>
> Regards, Hans Henrik Krohn
>
>
>
Received on Tue Apr 11 2000 - 16:06:32 CEST