Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Particular Export and Import
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 - 00:00:00 CDT