Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [HELP]sqlldr question
"Hantie" <blk330ci_at_hotmail.com> wrote in message news:d847dc$hd2_at_imsp212.netvigator.com...
|I am using sqlldr to perform bulk insertion, however, I would like to config
One idea might be to create a temporary staging table, and load that up with SQLLDR.
If no errors were encountered, then drop the original table and rename the staging table to suite.
If errors were encountered during the loading process, then you could easily truncate the staging table and try again without hurting the real table.
Just an idea.
Cheers,
Chris Val
Received on Tue Jun 07 2005 - 21:39:40 CDT