mysql error no. 150
Posted by: krishna kk
Date: November 10, 2008 01:29AM

Helloo

Wish you all a wonderful day.

I have imported data from oracle 10g database to mysql using MySQLMigrationTool.


But i couldnt import 4 tables as error 150 occurs..

pls help

create schema are included below

DROP TABLE IF EXISTS `mtest`.`comcurrencyrules`;
CREATE TABLE `mtest`.`comcurrencyrules` (
`currencyrulecode` DECIMAL(22, 0) NOT NULL,
`effectfromdate` DECIMAL(22, 0) NOT NULL,
`remarks` VARCHAR(256) BINARY NULL,
`currencycode` BIGINT(10) NULL,
`status` BIGINT(10) NULL,
PRIMARY KEY (`currencyrulecode`),
CONSTRAINT `currencycodef_k` FOREIGN KEY `currencycodef_k` (`currencycode`)
REFERENCES `mtest`.`comcurrencymaster` (`currencycode`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = INNODB;


Error is Can't create table '.\nov6\comcurrencyrules.frm' (errno: 150)
-------------------------------------------------------------------------
CREATE TABLE `mtest`.`comtdsrules` (
`tdsrulecode` DECIMAL(22, 0) NOT NULL,
`effectfromdate` DECIMAL(22, 0) NOT NULL,
`remarks` VARCHAR(256) BINARY NULL,
`naturepaymentcode` BIGINT(10) NULL,
`status` DECIMAL(22, 0) NULL,
PRIMARY KEY (`tdsrulecode`),
CONSTRAINT `naturepaymentcode_f_k` FOREIGN KEY `naturepaymentcode_f_k` (`naturepaymentcode`)
REFERENCES `mtest`.`comtdsnaturepaymentmaster` (`naturepaymentcode`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = INNODB;


Error is Can't create table '.\nov6\comcurrencyrules.frm' (errno: 150)
-------------------------------------------------------------------------


CREATE TABLE `mtest`.`mktcylindersub` (
`cmdetailcode` DECIMAL(22, 0) NOT NULL,
`cmmaincode` DECIMAL(22, 0) NULL,
`cylindercode` DECIMAL(22, 0) NULL,
`issuedate` DECIMAL(22, 0) NULL,
`receivedflag` VARCHAR(20) BINARY NULL DEFAULT ('N'),
`cylindername` VARCHAR(62) BINARY NULL,
`cylinderid` VARCHAR(62) BINARY NULL,
`invoicecode` DECIMAL(22, 0) NULL,
`receiveddate` DECIMAL(23, 0) NULL,
PRIMARY KEY (`cmdetailcode`)
)
ENGINE = INNODB;


Error is : You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
----------------------------------------------------------------------------
CREATE TABLE `mtest`.`mktproductpricingtaxdetails` (
`prdprcingtaxdetailscode` INT(5) NOT NULL,
`comtaxrulesdetcode` INT(5) NULL,
`pricingcode` INT(5) NULL,
PRIMARY KEY (`prdprcingtaxdetailscode`),
CONSTRAINT `mkt_comtax_ruldet_fk` FOREIGN KEY `mkt_comtax_ruldet_fk` (`comtaxrulesdetcode`)
REFERENCES `mtest`.`comtaxrules_details` (`comtaxrulesdetcode`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `mkt_pricing_code_fk` FOREIGN KEY `mkt_pricing_code_fk` (`pricingcode`)
REFERENCES `mtest`.`mktprodpricingmain` (`pricingcode`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = INNODB;

Error is Can't create table '.\nov6\comcurrencyrules.frm' (errno: 150)
-------------------------------------------------------------------


waiting for ur reply..

Options: ReplyQuote


Subject
Written By
Posted
mysql error no. 150
November 10, 2008 01:29AM
January 18, 2009 06:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.