| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader-417 Error
Stephen:
I will probably stay with the conventional load and if I hid any FK constraint problems I'll look into disabling the constraint. I'm doing a DB conversion into 8.1.7 with no application software connected to it. The DB is pretty much a duplicate of the production DB.
I am creating individual ctl load scripts for each table that I am loading. I want to put them all into a single ctl control file so I don't have to run them one at a time. I would like to know if it is possible to have say one script using direct path load and the other using conventional path load in the same main ctl script?
Thanks,
Ken
-----Original Message-----
Sent: Friday, December 14, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L Subject: Re: SQL*Loader-417 Error
Ken,
You can't do a lot of things to the data in a direct path load. You could modify your source data (awk, grep, sed, etc.) so you wouldn't need to reformat the date field and then if there are no additional problems, you will still have a problem with the FK that you are seeing in the conventional load.
Not knowing the FK error, I can't really point you towards a solution
there. I would probably just stick with conventional since it is easier
than mucking around with your source data. FK violations are good. They
mean you are not putting garbage into your database so you won't get
GIGO.
If you provide more info on your layout and the FK error I'm sure
someone will be able to help.
If you have any questions, please feel free to drop me a note.
Stephen Andert
Scottsdale, Arizona
>>> ken.janusz_at_sufsys.com 12/13/01 15:52 PM >>>
I am getting the following error for this line of code in my control
file
Any ideas of how I can get around this? When I try a conventional path
load
I get a FK constraint error (not on this field).
creation_date "to_date('01/01/2002','dd/mm/yyyy')",
SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in
direct
path.
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
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).
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 Fri Dec 14 2001 - 10:39:42 CST
 |
 |