The prerequisites for using the migrateadvisor command are:

• Oracle Database 11g Release 2 and later versions are supported.

• The PROPERTIES command is available only if the connected user is granted the SELECT ANY DICTIONARY privilege.

• The ADVISE command is available only if the connected user is granted:

  • the SELECT ANY DICTIONARY privilege
  • the SELECT privilege to access SYSTEM.DUM$COLUMNS and SYSTEM.DUM$DATABASE

    Note:

    You need access to the DUM$ tables only if the source and target character sets indicate that Oracle Database Migration Assistant for Unicode (DMU) is needed.