RE: Recommenations for a DB conversion using SQL Loaderf

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: peter.lomax_at_ftms.fr
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:ken.janusz_at_sufsys.com] 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_at_su       To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    fsys.com>            cc:

                    Sent by:             Subject:     Recommenations for a
DB conversion using SQL Loaderf          
                    root_at_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_at_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_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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: ken.janusz_at_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_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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: peter.lomax_at_ftms.fr

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