Symptom
The user created their tables in the SYSTEM schema and when they try to use Convert Schema or Migrate data for the SYSTEM schema the options are greyed out.
Cause
SSMA does not migrate system objects
Resolution
SSMA considers all objects in SYS and SYSTEM schemas as system objects. SSMA does not migrate objects which is considered to be system objects of Oracle in SSMA intentionally. Creating objects in another schema and do the migration.
More Information
Article Id: KBO2SS1010
Applies to
SSMA 2005 for Oracle
SSMA 2008 for Oracle
No comments:
Post a Comment