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..