OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Copy command

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copy command [message #250361]

Mon, 09 July 2007 15:02

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

Report message to a moderator

Re: Copy command [message #250363 is a reply to message #250361]

Mon, 09 July 2007 15:10

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: Copy command [message #250577 is a reply to message #250361]

Tue, 10 July 2007 09:15

joy_division
Messages: 4963
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

Report message to a moderator

Previous Topic:	Export tables and data from 8192(Block Size) to 4096(Block Size) database
Next Topic:	Export and import utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:39:49 CDT 2024