Re: sqlplus copy command fails when copying null varchar2 column - any ideas?
From: <Christopher.Jones_at_oracle.comX>
Date: 12 Jul 2002 11:25:10 +1000
Message-ID: <uu1n5d9ft.fsf_at_oracle.comX>
Date: 12 Jul 2002 11:25:10 +1000
Message-ID: <uu1n5d9ft.fsf_at_oracle.comX>
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 Fri Jul 12 2002 - 03:25:10 CEST