Home » RDBMS Server » Server Utilities » Copy command
Copy command [message #250361] Mon, 09 July 2007 15:02 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

While running this copy command i am getting the following error.

ORA-01458: invalid length inside variable character string


Command: copy from lc_feed/lc_feed@lnlcsuu1 to lc_feed/lc_feed@lnlcsuu1
insert JP_FACE_RAW_TDALLOCATION_NEW using select * from JP_FACE_RAW_TDALLOCATION e
where tradedate between '31-DEC-2005' and '30-JUN-2006';


Thanks in advance
Re: Copy command [message #250363 is a reply to message #250361] Mon, 09 July 2007 15:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing between '31-DEC-2005' and '30-JUN-2006' as '31-DEC-2005' is greater than '30-JUN-2006':
SQL> select * from dual where '31-DEC-2005' <= '30-JUN-2006' ;

no rows selected

SQL> select * from dual where '31-DEC-2005' >= '30-JUN-2006' ;
D
-
X

1 row selected.

Regards
Michel

Re: Copy command [message #250577 is a reply to message #250361] Tue, 10 July 2007 09:15 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Just to add to Michel's post, you are comparing character strings, as in:
FOO SCOTT>l
  1*  select * from dual where '31-DEC-2005' >= '#$%!'
FOO SCOTT>/

D
-
X
Previous Topic: Export tables and data from 8192(Block Size) to 4096(Block Size) database
Next Topic: Export and import utility
Goto Forum:
  


Current Time: Sat Dec 03 08:01:00 CST 2016

Total time taken to generate the page: 0.09286 seconds