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

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.

Comment on 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: 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
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.	[reply]
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.	[reply]