Might want to try the TRUNCATE keyword instead of the REPLACE keyword...?
Might go faster that way.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
llburrito_at_my-dejanews.com wrote in article
<6p39tg$mp9$1_at_nnrp1.dejanews.com>...
> I am trying to load a flat file from SQLLDR, and i keep getting a Oci
error
> while executing deleting(due to REPLACE KEYWORD)from table for table
> CUSTOMERMASTER. I thought that REPLACE is the keyword that enables me to
> replace the existing contents of the specified table. Also when i run
it, it
> takes about 1hr to run a sample of 100 entries into the table...so i know
> there must be something that i am missing. If anyone has any advice...i
> would be grateful Thanks, Jason Kraft
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Thu Jul 23 1998 - 11:17:15 CDT
