RE: Recommenations for a DB conversion using SQL Loader

From: Loughmiller, Greg <GLoughmiller_at_presolutions.com>
Date: Wed, 12 Dec 2001 11:51:06 -0800
Message-ID: <F001.003DB264.20011212114023@fatcity.com>

Previous conversion that we did-we also built the indexes after the data was there.. we had a ton of data.. And it was 3x faster to build the indexes and add constraints after the data got to the "destination"..

Greg

-----Original Message-----

Sent: Wednesday, December 12, 2001 12:42 PM To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Loughmiller, Greg
  INET: GLoughmiller_at_presolutions.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 - 13:51:06 CST