scjfan122yahoo.com wrote:
>>>>I have never seen the problem be anywhere except in the data itself. Look
>>>>for embeded carriage returns.
>>>
>>>
>>>I have tried with a long text string without any embeded carriage
>>>returns, and the loading process still fails. It turns out that any
>>>text string > 256 characters will be rejected by sql*loader. Is this
>>>possible a known bug for 8.1.6 sql*loader with a patch out there?
>>>Since I do not have a metalink account, can someone be kind enought to
>>>do a search? If there is a patch, I will appreciate if he/she can
>>>email it to me.
>>>
>>>Thanks,
>>>
>>>Simon
>>
>>8.1.6 is a known bug and has been desupported for years. Rather than
>>beating a dead horse why not spend your time doing something useful
>>like upgrading.
>>
>>BTW: Did you bother to patch to 8.1.6.2 or are you still using the
>>unpatched original release? Either way ... you are wasting time better
>>spent doing an upgrade.
>
>
> Due to the current company financial situation it has been impossible
> for me to get any Oracle support contract, upgrades, or patches for
> many years. The database server is running on Sun Solaris 2.6. I
> have no resources to upgrade the operating system either even if I can
> get hold of Oracle 9i software. I do not see this environment will
> change for good in any time soon. I guess I will just try to live
> with it by finding another way around this problem.
>
> Thanks,
>
> Simon
Contact me off-line and I can help you.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 22 2004 - 20:11:45 CDT
