Re: SQL*Loader Question?

From: Ed Prochak <prochak_at_my-dejanews.com>
Date: Wed, 21 Apr 1999 13:21:21 GMT
Message-ID: <7fkjce$vop$1@nnrp1.dejanews.com>

In article <7fjkph$5on$1_at_nnrp1.dejanews.com>, vishu2_at_hotmail.com wrote:
> Greetings,
>
> I was trying to load about 120 rows of data with the delimiter '%'
> using the following control file:
>

[]
>
> 2. Using the above procedure I am getting the following error using the
> Data Manager application:
> SQL*Loader-605: Non-data independent ORACLE error occured -
> load discontinued.
> Commit point reached - logical record count 22.
>
> I tried with just one row and still the same problem occurs.
> Also all the fields in the Oracle database table is varchar2.
>
> Any suggestions would be very greatly appreciated.
>
> Thanks in advance
> Vishwa
> vishu2_at_hotmail.com
>

I do not know for sure about your other problem, but this error usually indicates that your table is full. (Note the "Non-data dependent" phrase, which I think you miscopied.) Maybe you created it with the default storage and it has hit the limit on extents. Or your table space may be full. Ask your DBA.

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 21 1999 - 08:21:21 CDT