473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Loading Multiple CSV Files into Oracle DB

Okay here is my problem...

I have multiple csv files with data in each file. They are connected via foreign keys (with each table having its on primary key). I want to load these tables into an Oracle database using SQL or any other method u can think of. I know the order in which the tables should be loaded so do i go about loading the tables into the Oracle db.

E.g.

// CSV 1
Fields = ID_NUMBER | Name | Date
Data = 12345 (PK)| Hafiz | 12-12-2008 |

// CSV2
Field = ID_PRODUCT_ NUMBER | ID_NUMBER | Colour | Type
Data = 54321 (PK) | 12345 (FK) | Black| Car |

// Oracle Table 1
Fields = ID_NUMBER | Name | Date
Data = BLANK

// Oracle Table 2
Field = ID_PRODUCT_ NUMBER | ID_NUMBER | Colour | Type
Data = BLANK

The Oracle DB has the tables setup with the same field name. I want to load CSV 1 first into Oracle Table 1 and then CSV 2 into Oracle Table 2 (must be in this order or will run into referential integrity issues).

The next step is to make the solution applicable to csv files with 100 lines of data each (probably using some sort of iterative process). I've tried using SQL Loader but haven't had much luck. Can someone help??????????
Aug 11 '08 #1
1 4018
debasisdas
8,127 Expert 4TB
what is the problem with SQL LOADER ?
Aug 12 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Rachel Pevtzow | last post by:
i currently have a few (non-oracle) databases containing personal papers of wellington, mountbatten, etc. i'm thinking about moving it into oracle, but i'm worried about how to get the data in. ...
1
by: Cindy Lee | last post by:
I need to insert rows into MySql database from oracle, which I imagine is a rather common task. The path I decided to take is write a java procedure, as recommended in the manual. However, java...
1
by: Nikola Pecigos | last post by:
Hi, I have the following problem: We have an Oracle 9.2 with one table "document" which contains a path to the filesystem. If I want to index these files (HTML, PDF, World, Excel, etc.), I...
5
by: Shuaib | last post by:
I wonder if anybody could shed some light on a problem I am encountering. I have written a program in C that runs on Solaris 2.8. At busy times of the day there may be multiple instances of it...
0
by: dioscuroi | last post by:
When I call OCI (Oracle Call Interface) functions in Debug mode of VC+ 7.0, it takes too much time to load oracle debug symbols, and finall failed. Error messages are printed in output window, just...
2
by: Jeff Kish | last post by:
Hi. I need to give my customer an sql file that they can run in query analyzer. All the stuff they need to run is in a set of existing files. I'd like to just tell them to load this file (this...
7
by: =?Utf-8?B?QVRT?= | last post by:
HOWTO Run multiple SQL statements from ASP/ADO to an Oracle 10g. Please help, I'm trying to write an ASP page to use ADO to run a long query against an Oracle 10g database, to create tables,...
0
by: dave32079 | last post by:
I am moving data from Oracle to MS SQL 2000. I have been given the Oracle table structures and about 130 CVS files to populate these structures, 1 file per table. I have converted the table...
0
by: mayurshah28 | last post by:
Hi everyone, im developing one application for banking. there i have stucked wit one prob. now prob is tat im not able to access multiple tables at a time through vb. my coding is as below Dim...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.