OraFAQ Forum: MySQL » datatype of BLOB and CLOB on mysql database to oracle database (merged)

Home » Open Source » MySQL » datatype of BLOB and CLOB on mysql database to oracle database (merged) (mysql 5 and oracle 10g database)

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

datatype of BLOB and CLOB on mysql database to oracle database (merged) [message #513943]

Thu, 30 June 2011 06:46

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 01:55:30 CDT 2025