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