Cannot see SCOTT schema in Metadata explorer

Symptom

The user cannot see the SCOTT schema in the Oracle Metadata explorer. They can see SYS and SYSTEM schemas.

Cause

SCOTT schema is not selected in Project settings/Default Project Settings.

Resolution

The Loading System Objects page of the Project Settings dialog box lets you specify which Oracle system objects, SSMA converts and loads into SQL Server.

The Loading System Objects pane is available in the Project Settings and Default Project Settings dialog boxes:

To specify settings for all SSMA projects, on the Tools menu, select Default Project Settings, click General at the bottom of the left pane, and then click Loading System Objects.

To specify settings for the current project, on the Tools menu, select Project Settings, click General at the bottom of the left pane, and then click Loading System Objects.

More Information

Article Id: KBO2SS1003

Applies to

SSMA 2005 for Oracle

SSMA 2008 for Oracle