Re: Recommenations for a DB conversion using SQL Loader

Depending on how much data you have, look at doing a little tuning of the BINDSIZE and ROWS parameters. Send me a personal e-mail if you want more information on that.

Stephen Andert
Scottsdale, Arizona
>>> jeffcox_at_usa.com 12/12/01 11:35 AM >>>
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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: stephenandert_at_firsthealth.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).