Home » Other » General » Urgent request
Urgent request [message #104331] Fri, 24 September 2004 03:17 Go to next message
Niraj
Messages: 3
Registered: April 2002
Junior Member
We receive the csv dump for the entire database (consisting 23 tables ) approx 200 MB from the third party daily.

What is the best way to import these csv files into our database.

The csv file may contain the changes in only one record of the entire table, so it is not a good idea to delete and import the entire table again.

Please suggest.

Regards

Report message to a moderator

Re: Urgent request [message #104443 is a reply to message #104331] Sat, 16 October 2004 06:04 Go to previous message
JAC
Messages: 12
Registered: February 2003
Junior Member
You could try using a 3rd party utility to compare the .csv files from the previous day and generate a result set and only import the result. I have not personally tried this method, but here is a link to help you.

http://www.popularshareware.com/Excel-Compare-download-2361.html

Its free to try.
HTH

Report message to a moderator

Previous Topic: How oracle can give me business advantages & competitive edge.
Next Topic: Problems with Oracle9i Report Builder
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 06:53:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.