Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reg. SQL Loader.

Re: Reg. SQL Loader.

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Fri, 29 Dec 2000 15:25:36 -0400
Message-Id: <10725.125466@fatcity.com>


On Fri, 29 Dec 2000, you wrote:
>
> Hai,
>
> Hope this helps,
>
> INSERT
> This is the default method. It requires the table to be empty before loading. SQL*Loader terminates with an error if the table contains rows.
> APPEND
> If data already exists in the table, SQL*Loader appends the new rows to it. If data doesn't already exist, the new rows are simply loaded.
> REPLACE
> All rows in the table are deleted and the new data is loaded. The table must be in your schema, or you must have DELETE privilege on the table. The row deletes cause any delete triggers defined on the table to fire. If DELETE CASCADE has been specified for the table, then the cascaded deletes are carried out, as well.
> Updating Existing Rows
> The REPLACE method is a table replacement,

Don't forget the 'truncate' option for quick deletes (must own the table or have 'drop any table' privilege for the truncate option to work).

Cheers,
GC

-- 
"The opposite of a correct statement is a false statement. But the opposite 
of a profound truth may well be another profound truth." 
                                    --Niels Bohr
Received on Fri Dec 29 2000 - 13:25:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US