Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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

by metadatum (Scribe)
on Jan 24, 2002 at 19:54 UTC ( [id://141226]=note: print w/replies, xml ) Need Help??


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

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.
  • Comment on Re: Re: Re: DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader

Replies are listed 'Best First'.
Re: Re: 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 21:32 UTC
    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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://141226]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (3)
As of 2024-04-25 19:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found