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.
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: 58644
Registered: March 2007
Location: Nanterre, France, http://...
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
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: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://forums.oracle.com/forums/thread.jspa?messageID=2040187
Previous Topic: How many MSSQL DBs are present on a server?
Next Topic: max_connection_per_hours
Goto Forum:
  


Current Time: Sat Aug 02 00:30:33 CDT 2014

Total time taken to generate the page: 0.09491 seconds