Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reg. SQL Loader.
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 BohrReceived on Fri Dec 29 2000 - 13:25:36 CST
![]() |
![]() |