Home » RDBMS Server » Server Utilities » migration from Sybase to oracle 1 table fails with SQL Error: ORA-01841: (full) year must be between (Oracle 11G linux )
migration from Sybase to oracle 1 table fails with SQL Error: ORA-01841: (full) year must be between [message #560901] Tue, 17 July 2012 13:35 Go to previous message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
Hello
im trying to migrate Sybase 12.5 to oracle 11G R2 on linux all tables are fine expect one which fails with error

"SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range"

i have change the data type from CHAR to VARCHAR2 etc as for the datatype date shows as date on the tool - I'm using sqldeveloper from oracle

any help would be great

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: export datapump issue
Next Topic: SQLLDR connection error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 18:13:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.