Hello,
We are trying to migrate a SQL Server DB to Oracle 12c using SQL Developer's migration wizard.
We are getting some errors. I was wondering if migration to 12c is supported yet. We were successfully able to migrate to 11g using the same tool.
The errors we are getting seems to be related to set up. When SQL developer is creating migrations script, it is trying to create a common role with name " 'ROLE_SUITES_SQL_SERVER_TO_ORA' .
However in 12c ,the name of common role must start with C## or c## . Therefore the script execution is failed. This led me to think that SQL Developer is creating a script which is not compatible to 12c.
Here is the error:
Creating Role ROLE_Suites_SQL_Server_to_Ora ...
Error starting at line : 18 File @ C:\Users\Documents\Port_Suites_to_Oracle_DB\LogFiles\Suites_SQL_Server_to_Ora12c\generated\2014-11-05_00-21-01\master.sql
In command -
CREATE ROLE ROLE_Suites_SQL_Server_to_Ora
Error at Command Line : 18 Column : 13 File @ C:\Users\Documents\Port_Suites_to_Oracle_DB\LogFiles\Suites_SQL_Server_to_Ora12c\generated\2014-11-05_00-21-01\master.sql
Error report -
SQL Error: ORA-65096: invalid common user or role name
65096. 00000 - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to
the usual rules for user and role names, common user and role
names must start with C## or c## and consist only of ASCII
characters.
*Action: Specify a valid common user or role name.
Can someone throw light on it please?
Thanks for all the help in advance!