Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus copy command fails when copying null varchar2 column - any ideas?
djpotter77_at_hotmail.com (Dervish) writes:
> 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?
Sounds like bug 898213, fixed three years ago for the 8.1.6 release.
Will CREATE TABLE AS SELECT work for you? This is generally faster because it does not require data to be sent between Oracle and SQL*Plus across Oracle Net.
Chris
-- Christopher Jones, Oracle Corporation, Australia.Received on Thu Jul 11 2002 - 20:25:10 CDT