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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Andert
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Ken Janusz
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
