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