it's not sql loader -- it's part of the sql command to enable the constraint
look at 'alter table' in the SQL manual --- Ken Janusz <[EMAIL PROTECTED]> wrote: > Thanks for the info. I looked in Oracle8i Utilities in the SQL > Loader > section and could not find anything about the 'exceptions into' > clause. > > Where should I look? > > Thanks, > Ken > > > -----Original Message----- > Sent: Wednesday, December 12, 2001 12:41 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Recommenations for a DB conversion using SQL Loaderf > > > > Ken, > > That's one way to do it. If your data is very large it will make the > loading much faster. > > You can alleviate this by loading the tables in order of parents > first. If you don't have an database diagram you can generate > this information from dba_constraints. > > The easiest way is probably to disable the constraints, load > the data, then enable the constraints. > > Be sure to thouroghly read the fine manual regarding constraints, > particularly the 'exceptions into' clause. > > By redirecting exception rowids into another table you can > easily determine any rows that are causing a problem. > > The way I do it if there is a lot of data and constraints to deal > with is to send exceptions to an exceptions table, move any > exception rows to another table, enable the constraint, and > then determine why the exception rows were excepted, > correct the problem and insert the row. > > I haven't done this for awhile, and there may be new features > in 'ALTER TABLE ENABLE CONSTRAINT' that would change > this scenario somewhat, hence the RTFM. > > HTH > > Jared > > > > > > > Ken Janusz > > <ken.janusz@su To: Multiple recipients > of list > ORACLE-L <[EMAIL PROTECTED]> > fsys.com> cc: > > Sent by: Subject: Recommenations > for a > DB conversion using SQL Loaderf > [EMAIL PROTECTED] > > om > > > > > > 12/12/01 08:45 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > I am working on a one time DB conversion project for a state > government > entity. I have a DB (8.1.7 on W2000 server) setup without the > application > SW that I am using to load the data into from flat files. When I get > this > data loaded I will then load it into the production tables at the > client > site. I will not be running any applications on this DB, it's for > conversion purposes only. I am running into some constraint > violation > problems since I am loading the data to each table one at a time. > Would it > be prudent to disable the constraints until I get all the data > loaded? > Any and all suggestions are welcome. > Ken > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).