Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader

by wardk (Deacon)
on Jan 24, 2002 at 04:12 UTC ( #141077=note: print w/ replies, xml ) Need Help??


in reply to DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader

well this isn't a DBI solution, but it's in "perl", and it works on my production system.... just set up the sql*load control files and run them from perl, capturing the output...

my @aap_rc = `cd /web/$gsVersion/bess/db;$ENV{ORACLE_HOME}/bin/sqll +oad $ORACLE_ACCT/$ORACLE_PW CONTROL=/web/$gsVersion/bess/db/aap.ctl L +OG=/web/$gsVersion/bess/db/aap.log`;


Comment on Re: DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader
Download Code
Re: Re: DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader
by joealba (Hermit) on Jan 24, 2002 at 07:36 UTC
    Heh. Thanks!

    I have this solution as a backup right now. But, I haven't given up on that "direct load insert" thing.

    When I find (or write) a way to make this happen, I'll post it here. :) But, I WILL make this work.
      How are you trying to do the direct load insert? It should be as easy as: insert /* +APPEND */ into tableA (name, address) values ("Joe", "123 Main St"); The APPEND hint tells Oracle to use direct load insert.
        Well, I'm creating a temporary table with one column - 'filename'. I want to load a list of 2000 rows into the temporary table very quickly. From my research on groups.google.com, I found a reference to "direct load insert" that seemed to accomplish this in an optimal way. My interpretation could certainly be wrong, though.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://141077]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2014-09-21 20:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (176 votes), past polls