Monday, August 3, 2009

Cannot Convert Schema or Migrate data for SYSTEM schema

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