How to resolve the err:150 for creating the table with storage ENGINE = INNODB;

[niranjan reddy]

hi,

we am creating table in mysql from oracle using "mysql migration tool kit"

script:

CREATE TABLE `TTB`.`TTB_TRANSACTION` (
`TT_TRANS_ID_PK` INT(8) NOT NULL,
`TT_COMMENTS` VARCHAR(200) BINARY NULL,
`TT_DESC` VARCHAR(600) BINARY NULL,
`TT_PARTICIPATED_PROCESS_NAME` VARCHAR(150) BINARY NULL,
`TT_PARTICIPATED_TABLE_NAME` VARCHAR(150) BINARY NOT NULL,
`TT_STATUS` VARCHAR(50) BINARY NOT NULL,
`TTPA_TT_TRANS_PROCE_APPR_ID_FK` INT(8) NOT NULL,
`TT_TRANS_ERROR` VARCHAR(150) BINARY NULL,
`TT_TRANS_NAME` VARCHAR(150) BINARY NULL,
`TT_TRANS_PHASE` VARCHAR(150) BINARY NOT NULL,
`TT_TRANS_TYPE` VARCHAR(150) BINARY NULL,
`TT_ROW_CREATE_BY` VARCHAR(50) BINARY NOT NULL,
`TT_ROW_CREATE_DATE` DATETIME NOT NULL,
`TT_ROW_UPDATE_BY` VARCHAR(50) BINARY NOT NULL,
`TT_ROW_UPDATE_DATE` DATETIME NOT NULL,
`TT_ROW_LAST_UPDATE_LOGIN` VARCHAR(50) BINARY NOT NULL,
`TT_ATTRRIBUTE1` VARCHAR(1000) BINARY NULL,
`TT_ATTRRIBUTE2` VARCHAR(1000) BINARY NULL,
`TT_ATTRRIBUTE3` VARCHAR(1000) BINARY NULL,
`TT_ATTRRIBUTE4` VARCHAR(1000) BINARY NULL,
`TT_ATTRRIBUTE5` VARCHAR(1000) BINARY NULL,
PRIMARY KEY (`TT_TRANS_ID_PK`),
CONSTRAINT `TTB_TRANSATTION_TTB_TRANS_FK1` FOREIGN KEY `TTB_TRANSATTION_TTB_TRANS_FK1` (`TTPA_TT_TRANS_PROCE_APPR_ID_FK`)
REFERENCES `TTB`.`TTB_TRANS_PROCESS_APPROVAL` (`TTPA_TRANS_PROCESS_APROV_ID_PK`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = INNODB;

we are getting error:
cannot create table TTB/TT.TRANSACTION.frm errno: 150

plz help us.

thanks&Regards,
niranjan.



Edited 1 time(s). Last edit at 03/27/2009 11:26PM by niranjan reddy.