Re: SQL*Loader question

In 7.3.4, Oracle marks the index as in direct load state and if there are no problems when the load is finished, will re-enable constraints and rebuild indexes.

O8 is much the same, except the status, if checked is unavaiable.

Terry

"Oak, Sameer" wrote:

> Hi gurus
>
> This might be simple question for gurus..
>
> When one users direct load in SQL*loader what happens to the constraints on
> that particular table????
> What I mean is do we have to reapply the constraints & rebuild the
> indexes????
>
> Also what about triggers on the table????
>
> Tia
> $ameer
>
> --
> Author: Oak, Sameer
> INET: Sameer.Oak_at_CWUSA.COM
>
> 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_at_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).
Received on Wed Jun 14 2000 - 15:35:50 CDT