Re: SQL Loader question

From: Johnny Chopra <johnnyc_at_mail.starnet.com.au>
Date: 1997/05/06
Message-ID: <5kn4bs$knm$1@perki0.connect.com.au>#1/1

In article <336DCA36.5A1A_at_mail.icon.co.za>, John Stathakis <jlstath_at_mail.icon.co.za> says:
>
>
>Sandeep Goel wrote:
>>
>> How to create exceptions table to handle exceptions encountered during a
>> load.
>>
>> Thanks
>

Hi Sandeep,
 There is script called utlexcpt.sql or utlexpt to create exception table  Provided by oracle.You can search for this script in $ORACLE_HOME.  Once the table is created You can say.
 for eg.
 Alter table table_name enable constraint constraint_name

                                          exceptions into exception_table

you just created.
Thanks.
Johnny Chopra Received on Tue May 06 1997 - 00:00:00 CDT