MySQL Forums
Forum List  »  Oracle

Oracle Integer(38) converted to Decimal(22,0)
Posted by: Adil Alvi
Date: April 20, 2009 11:21AM


I migrated an oracle database to MySQL using the MySQL Migration Toolkit. All columns in Oracle which are of Integer (38) data type are converted to Decimal(22,0) in MySQL. Will the decimal data type allocate storage depending on the value of the field or will it always allocate a fixed storage size i.e (22,0)?

If I manually convert the decimal data type to INTEGER, can someone also give the steps, where I can disable the constraints, alter the data type, and then enable the constraints again.
There are at least 20 to 30 instances, and they all have referential constraints. If there is no storage or performance issue by keeping the decimal data type, then please advise so.


Options: ReplyQuote

Written By
Oracle Integer(38) converted to Decimal(22,0)
April 20, 2009 11:21AM

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.