Re: SQL*Loader and LOBFILES, cannot span transactions

It looks like you probably have a record where the file name has an embedded carriage return in it. Clear out the C.R. and try again.

JP

david_at_vanhorn.com (David Van Horn) wrote in message news:<f3f332ed.0203201849.33cb2de0_at_posting.google.com>...
> I am having trouble importing using SQl*Loader and LOBFILES.
>
> I am using the following CONTROL file for SQL*Loader...
>
> LOAD DATA
> INFILE 'import.dat'
> INTO TABLE Documents
> APPEND
> FIELDS TERMINATED BY '`'
> ( document_id SEQUENCE (MAX,1),
> name,
> ...
> ext_fname FILLER CHAR(80),
> text LOBFILE(ext_fname) TERMINATED BY EOF)
>
> and my import.dat file looks like this....
>
> somename`...`text/doc.00000.txt
> somename`...`text/doc.00001.txt
> ....
> somename`...`text/doc.99999.txt
>
> And when I run SQL*Loader everything starts off fine, giving me output
> like this...
>
> Commit point reached - logical record count 34
> Commit point reached - logical record count 68
> ...
>
> Until I get to some point along the way where this happens...
>
> ...
> Commit point reached - logical record count N
> ORA-22990: LOB locators cannot span transactions
>
> Where N is some number, usually between 2000 and 4000, but it does
> vary.
>
> What is going wrong here?
> I read the documentation about LOB locators can not span transactions,
> but this doesn't seem to apply to what I am doing.
>
> Any suggestions would be greatly appreciated.
>
> -David
Received on Fri Mar 22 2002 - 20:04:29 CET