Re: sqlplus copy command fails when copying null varchar2 column - any ideas?

Thanks for the responses.

It turns out this only happens if every value in the table for the varchar2 column is NULL. Still a problem, but I could potentially use 'create table as select ...'. That works. However, it was my impression that the copy command was faster for large sets of data being pulled across a network from one db to another. I'll have to test this though.

Regards,
Daniel

djpotter77_at_hotmail.com (Dervish) wrote in message news:<30e064e9.0207110530.43e1cdcc_at_posting.google.com>...
> Hey all,
> I am getting an Oracle error (ORA-01458) when I attempt to use the
> sqlplus copy command to copy from any table that has at least one row
> with a null value for any varchar2 column. I am using Oracle 8.1.5
> NT.
>
> Has anyone else encountered this error? Is it a bug in 8.1.5? Any
> suggestions on how to get around it?
>
> Thanks in advance!
> Daniel
Received on Fri Jul 12 2002 - 16:25:00 CEST