December 17, 2009 at 10:49 am
I am trying to migrate an Oracle 10 database to SQL Server 2005, with SSMA. However, not all the schemas are showed up in the SSMA. I am using the system account to connect to oracle. In Oracle Enterprise Manager, I could see more schemas than those I could see in SSMA.
Any one has an idea about this?
Thanks.
December 29, 2009 at 9:53 am
It's never a good idea to connect to Oracle using either SYS or SYSTEM account just to select from some tables.
Ask your Oracle DBA to create an account for migration purposes, ask him/her to grant "select any table" system privilege to such account.
On the other hand, SSMA may be smart enough not to show empty schemas; in the Oracle world a schema is nothing but the collection of objects owned by a specific account so most GUI interfaces would shows a "schema" for any and all accounts defined in the system even if some of them own no object.
_____________________________________
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.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply