Re: Recommenations for a DB conversion using SQL Loader

Ken,

A few things you could try here:

1. disable the foreign key constraints for the load or
2. load the parent tables before the child tables

If you have a huge amount, you might want to consider dropping all of the indexes, except for the primary and unique key constraints. (I don't like to take chances when it comes to data integrity.) This would save you a boatload of time.

Regards,

Jeff

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 12, 2001 9:45 AM

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: JeffCox
  INET: jeffcox_at_usa.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).