Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01406: fetched column value was truncated
ORA-01406: fetched column value was truncated [message #360387] Thu, 20 November 2008 15:45 Go to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

Hi,

i have run the following command in my hunuat user.

SQL>COPY to citiretro01/cosmos@cititest10g.world create constraints_hun USING -
SELECT * from dba_constraints@hunprod where owner ='FCCHUN'

ERROR:
ORA-01406: fetched column value was truncated

how can i copy this in my citiretro01 user.

thanks & regards,
Manju
Re: ORA-01406: fetched column value was truncated [message #360401 is a reply to message #360387] Thu, 20 November 2008 20:49 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Seems to work for me. Please post your version info.

SQL> set long 99999
SQL> set arraysize 1
SQL> copy to kevin@orcl create a using select * from dba_constraints;

Array fetch/bind size is 1. (arraysize is 1)
Will commit when done. (copycommit is 0)
Maximum long size is 99999. (long is 99999)
Table A created.

   7078 rows selected from DEFAULT HOST connection.
   7078 rows inserted into A.
   7078 rows committed into A at kevin@orcl.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> 


Kevin
Re: ORA-01406: fetched column value was truncated [message #360635 is a reply to message #360387] Fri, 21 November 2008 13:17 Go to previous message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

Thanks, it works.
Previous Topic: SUM of records
Next Topic: Single query using different column from different table
Goto Forum:
  


Current Time: Mon Dec 05 04:42:46 CST 2016

Total time taken to generate the page: 0.15257 seconds