Re: Particular Export and Import

From: Alan Moorman <alm2_at_XYZemail1.dss.state.va.us>
Date: Mon, 10 Apr 2000 17:17:47 -0400
Message-ID: <NvrI4.1$r5.66_at_dit4.state.va.us>


Riccardo,

The only way I know that you could do a "conditional export" is to create a temporary table as select from permanent table where your condition is met, then EXP the temporary table.

I've never seen a way to do a "conditional import".

Why couldn't you just apply the same logic, avoiding EXP & IMP, by using a temporary table?

Alan
Riccardo D.S. wrote in message
<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?
>
>When I import from the ".dmp" file into a same Table, is it possible
>to insert these records without delete all record already present?
>If the PK's values are present I do a Update,
>if the PK's values are new I do a Insert.
>
>
>Sorry
>for my English
>I prefer Pizza and Pasta.
>
>Riccardo Di Stefano
>(AMS - Italy)
>
Received on Mon Apr 10 2000 - 23:17:47 CEST

Original text of this message