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: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: 2000/04/10
Message-ID: <8culpf$4lk$1@newsg4.svr.pol.co.uk>#1/1

Hi,

If you deal with not too many records, say up to 30.000 or 60.000 you can consider going via Excel/Oraxcel. Oraxcel will allow you to effectively export data into Excel spreadsheets and reload them from there. With a little effort you can do smart things like only update the data that has changed since the import. In fact I'm doing this for a client at the moment; setting up a spreadsheet that brings the live data inline with an older export.

Have a look at Oraxcel at http://www.oraxcel.com

If you need directions on how to do this in ernest, drop us a line at gjlinker_at_oraxcel.com

Regards,

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE

Riccardo D.S. <rdistefano_at_aleniasystems.finmeccanica.it> wrote in message
news: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