Re: SQL Loader Headache!

In article <89s4gk$u8r$1_at_nnrp1.deja.com>,   liam_2e_at_my-deja.com wrote:
> Hello Everyone
>
> I am currrently trying load data in to that have Foreign Keys and I am
> unable to do it. I have several tables in the schema that I am working
> on that don't take any foreign keys and I was able to load the data
> without any problem. Now that I am gettting to the tables that recieve
> foreign keys they will not load! I am doing everything the same and
 all
> of the tables which supply the current table with foreign keys are
> loaded. What is even more frustrating is that I am not getting any
> error messages the command prompt says that the records were loaded.
> When I check the table in sql plus nothing was loaded. Here is my
> control file and a clip of the dat. Thanks for the help!! Liam
>

What does the .log file say? The command line interface says how many records were read from the input file -- not how many loaded. The log file will reveal all.

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.