RE: SQL*Loader question

My understanding was.....you should drop indexes and re-create after the load. Constraints and triggers stay intact, and are enforced while inserting (should the trigger be on insert).

Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

From:	Oak, Sameer [SMTP:Sameer.Oak_at_CWUSA.COM]
Sent:	Tuesday, June 13, 2000 3:50 PM
To:	Multiple recipients of list ORACLE-L
Subject:	SQL*Loader question

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).