tag:blogger.com,1999:blog-6480555434853676325.post6106037588666738768..comments2023-07-13T04:04:51.867-06:00Comments on MySQL DBA - An Oracle DBA's Journey: Converting an Oracle Schema to MySQLAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6480555434853676325.post-31441602579822426952011-09-01T10:23:10.300-06:002011-09-01T10:23:10.300-06:00What about converting Oracle's TO_DATE to _STR...What about converting Oracle's TO_DATE to _STR_TO_DATE? I have had issues with this conversion, as it doesnt seem to work for me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-73758691766042773442010-04-30T02:12:59.337-06:002010-04-30T02:12:59.337-06:00I am oracle dba and doing setup for mysql. we are ...I am oracle dba and doing setup for mysql. we are migrating oracle db into mysql. <br />while setting up the database, I have create the use and granting only DML operations along with DDL. I am not able give trigger privilege? DO ineed to give user SUPER privieleg for getting trigger privilege?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-48649006327315516022009-06-11T18:39:29.772-06:002009-06-11T18:39:29.772-06:00Hi Roland,
Good point, I addressed in the line wh...Hi Roland,<br /><br />Good point, I addressed in the line where I pointed out:<br />Change NUMBER(x,x) to DECIMAL(x,x)<br /><br />However, its a good point to re-emphasize.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-22226218215200673022009-06-11T12:02:09.609-06:002009-06-11T12:02:09.609-06:00Hi!
Nice post. One but:
"Change NUMBER to I...Hi!<br /><br />Nice post. One but:<br /><br />"Change NUMBER to INT"<br /><br />heh - this is something to watch out for. NUMBER with no precision and scale specification can hold integer numbers as well as decimal numbers. So you need to analyze the schema and try to discover whether you can see a particular column name pattern for id columns - you can't just blindly map every rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.com