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] |
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] |