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 <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:
> 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).
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: wisernet100_at_yahoo.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).
Received on Wed Dec 12 2001 - 15:13:15 CST
