Re: SQL*Loader - what happened?

From: Joel Garry <joel-garry_at_home.com>
Date: 7 Apr 2003 16:34:35 -0700
Message-ID: <91884734.0304071534.78e77501_at_posting.google.com>


monicaroman_at_yahoo.com (Monica Roman) wrote in message news:<9eb77af5.0304070756.7b51e212_at_posting.google.com>...
> Hello,
> I am brand new to Oracle...took some classes but none taught me how to
> use SQL*Loader but I've been reading everything that I can including
> many (MANY) postings here and was able to understand what to do. So I
> ran my .ctl file and it seemed that it worked, except that when I
> Select From in SQL*Plus nothing shows. Please help? I am using Oracle
> Personal Server 9i Release 9.2.0.2.0

Look for a .log file that says what all is wrong. It will say whether you have bad data errors or all the constraints failed. If you don't have a .log file, specify one when you run the command.

jg

--
_at_home.com is bogus.
0 Rows not loaded because all WHEN clauses were failed.
Received on Tue Apr 08 2003 - 01:34:35 CEST

Original text of this message