Re: Uploading data for star schema
Date: Wed, 06 Dec 2000 10:22:52 GMT
Message-ID: <0soX5.115$VM5.135443456_at_news.telia.no>
Hello,
I have a situation that seems to be a bit the same.
What I do is that I create a large table, and use SQL*Loader with the Direct
Path Option (makes the load run very fast!) to load the whole file into this
table. Then I have packages of PL/SQL stored procedures that I run to
perform all the logic. These procedures loops through the large table with
cursors (I process 3000 rows in every cursor), and perform the inserts and
updates to the 'real' tables.
This is the best way I have found so far, maybe you can use some of it.
Best regards,
<sw_at_weinerfamily.org> wrote in message
news:3A2DCAEF.81A8587B_at_weinerfamily.org...
Randi Wølner
> Hi,
>
> This won't work for several reasons. For clarification:
> 1) I will be uploading several million rows and Access would explode
> 2) This process will be done regularly and some of the data will already
be
> in the database so if the record is already there I need to get the id.
If
> the records isn't there I need to pull the next valid id from a sequence
in
> Oracle.
> 3) That process is not automated (realized I didn't specify this) and this
> will be done weekly in an automated fashion
> 4) This process will be far slower performance wise than what I am already
> doing with VB.
>
Received on Wed Dec 06 2000 - 11:22:52 CET