Home » Open Source » MySQL » datatype of BLOB and CLOB on mysql database to oracle database (merged) (mysql 5 and oracle 10g database)
datatype of BLOB and CLOB on mysql database to oracle database (merged) [message #513943] Thu, 30 June 2011 06:46 Go to next message
funmi
Messages: 2
Registered: January 2008
Location: nigeria
Junior Member
I got the error below migrationg datatype of BLOB and CLOB on mysql database to oracle database


migration actions have failed. check the migration reports for details... ORA-01400:cannot insert NULL into "sys". "MD_PROJECTS". "ID"

kindly tell me what to do to resolve the issue above.

Report message to a moderator

Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #513948 is a reply to message #513943] Thu, 30 June 2011 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
into "sys". "MD_PROJECTS". "ID"

This hurts a lot.
NEVER use SYS for your data, it is for Oracle ONLY (and maintenance purpose).
Although here you use "sys" which should not exist as it is a bad idea to use lower case in Oracle names.

In the end, the error message is quite clear, "ID" column is declared as NOT NULL and you tried to insert a null value.

Regards
Michel

Report message to a moderator

Re: datatype of BLOB and CLOB on mysql database to oracle database [message #513962 is a reply to message #513943] Thu, 30 June 2011 07:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://forums.oracle.com/forums/thread.jspa?messageID=2040187

Report message to a moderator

Previous Topic: How many MSSQL DBs are present on a server?
Next Topic: max_connection_per_hours
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 11:31:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.