From orantdba@netscape.net Wed, 12 Dec 2001 13:36:49 -0800 From: orantdba Date: Wed, 12 Dec 2001 13:36:49 -0800 Subject: Re: Recommenations for a DB conversion using SQL Loaderf Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi Ken, You will use the exceptions into when re-enabling your constratings. --John ken.janusz@sufsys.com 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 > > ORACLE-L > fsys.com> cc: > > Sent by: Subject: Recommenations for a >DB conversion using SQL Loaderf > root@fatcity.c > > 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: ken.janusz@sufsys.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@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). > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: orantdba@netscape.net 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@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).