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: Particular Export and Import

Re: Particular Export and Import

From: Alan Moorman <alm2_at_XYZemail1.dss.state.va.us>
Date: 2000/04/10
Message-ID: <NvrI4.1$r5.66@dit4.state.va.us>#1/1

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

Original text of this message

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