Ken , there is only one book. :-) That is "SQL*Loader: The Definitive Guide by Gennick, Mishra" The pair explain very nice addons and features that are quite useful. As usual its an Oreilly book. Peter Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/AT&P OrangeFrance Bureau: email: [EMAIL PROTECTED] tel: (+33) (0)1 55 22 59 13 fax: (+33) (0)1 55 22 39 69 Simbad sailing through UMTS.
-----Message d'origine----- De : Ken Janusz [mailto:[EMAIL PROTECTED]] Envoy� : mercredi 12 d�cembre 2001 20:40 � : Multiple recipients of list ORACLE-L Objet : RE: Recommenations for a DB conversion using SQL Loaderf 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). -- 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).
