Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
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
Replies are listed 'Best First'.
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 scrutinizing the Monastery: (9)
As of 2015-07-08 01:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls