Re: Recommenations for a DB conversion using SQL Loaderf

Hi Ken,

You will use the exceptions into when re-enabling your constratings.

--John

ken.janusz_at_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
>
> <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: orantdba
  INET: orantdba_at_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_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).