|
-
 Originally Posted by raghu559
We are planning to change the name of the schema owner in oracle like ops$mysql_schema_owner how to accomplish this?
Create the new account, move all objects to the new schema.
Originally Posted by raghu559
Is there an option to only migrate few particular tables from a particular schema instead of entire MYSQL DATABASE?
I remember using oracle's migration workbench to migrate from SQL Server to Oracle and Yes... I remember migrating a single table.
That been said, not 100% sure about MySQL but since Oracle uses to be consistent on its products and MySQL is very SQL Server alike RDBMS I suppose this is also supported.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote