Message-Id: <10724.125428@fatcity.com> From: "Muthaiah" Date: Fri, 29 Dec 2000 10:10:54 +0530 Subject: Re: Reg. SQL Loader. This is a multi-part message in MIME format. ------=_NextPart_000_0061_01C0717F.A119C5E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hai, Hope this helps, INSERT=20 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=20 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.=20 REPLACE=20 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.=20 Updating Existing Rows The REPLACE method is a table replacement, With best regards, Muthaiah (Muths) If god be with us, Who can be against us ----- Original Message -----=20 From: Arul kumar To: Multiple recipients of list ORACLE-L Sent: Thursday, December 28, 2000 12:00 PM Subject: Reg. SQL Loader. > Hi All, >=20 > I got a doubt in SQL Loader. I want to load data into a table which is > already having some data . I mean , appending records. >=20 > Can anybody let me know the option or keyword to be given in the = control > file which will allow me to APPEND the records in a table. >=20 > TIA, > Arul. >=20 > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.com > --=20 > Author: Arul kumar > INET: rakumar@mahindrabt.com >=20 > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). ------=_NextPart_000_0061_01C0717F.A119C5E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hai,
Hope this helps,

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

With best=20 regards,


Muthaiah (Muths)

If god be with us, Who can = be=20 against us
----- Original Message -----
From: Arul kumar=20 <rakumar@mahindrabt.com>
To: Multiple recipients of list = ORACLE-L=20 <ORACLE-L@fatcity.com>
Sent: Thursday, December 28, 2000 12:00=20 PM
Subject: Reg. SQL Loader.


> Hi All,
>
> = I got a=20 doubt in SQL Loader. I want to load data into a table which is
> = already=20 having some data . I mean , appending records.
>
> Can = anybody let=20 me know the option or keyword to be given in the control
> file = which will=20 allow me to APPEND the records in a table.
>
> TIA,
> = Arul.
>
> --
> Please see the official ORACLE-L FAQ: = http://www.orafaq.com
> --
> Author: Arul = kumar
>  =20 INET: rakumar@mahindrabt.com
>
> Fat City Network=20 Services    -- (858) 538-5051  FAX: (858) = 538-5051
>=20 San Diego, California        -- = Public=20 Internet access / Mailing Lists
>=20 --------------------------------------------------------------------
&= gt; To=20 REMOVE yourself from this mailing list, send an E-Mail message
> = to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> = the=20 message BODY, include a line containing: UNSUB ORACLE-L
> (or the = name of=20 mailing list you want to be removed from).  You may
> also = send the=20 HELP command for other information (like=20 subscribing).
------=_NextPart_000_0061_01C0717F.A119C5E0--