Full Export and Import Of Workspace Manager Results In Fewer Objects Post Import (Doc ID 433536.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Workspace Manager - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Jan-2013***

Symptoms

Before a database export on 10.2, you observe that there are 242 objects in the WMSYS schema.
You exported the database and then imported into a new 10.2 database and you noticed that there are now only 215 objects in the WMSYS schema. The missing objects are:

AQ$WM$EVENT_QUEUE_TABLE VIEW VALID
AQ$WM$EVENT_QUEUE_TABLE_R VIEW VALID
AQ$WM$EVENT_QUEUE_TABLE_S VIEW VALID
AQ$_WM$EVENT_QUEUE_TABLE_E QUEUE VALID
AQ$_WM$EVENT_QUEUE_TABLE_F VIEW VALID
AQ$_WM$EVENT_QUEUE_TABLE_G TABLE VALID
AQ$_WM$EVENT_QUEUE_TABLE_H TABLE VALID
AQ$_WM$EVENT_QUEUE_TABLE_I TABLE VALID
AQ$_WM$EVENT_QUEUE_TABLE_N SEQUENCE VALID
AQ$_WM$EVENT_QUEUE_TABLE_S TABLE VALID
AQ$_WM$EVENT_QUEUE_TABLE_T TABLE VALID
AQ$_WM$EVENT_QUEUE_TABLE_V EVALUATION CONTEXT VALID
SYS_C002942 INDEX VALID
SYS_C002943 INDEX VALID
SYS_C002946 INDEX VALID
SYS_IOT_OVER_10153 TABLE VALID
SYS_IOT_TOP_10149 INDEX VALID
SYS_IOT_TOP_10151 INDEX VALID
SYS_IOT_TOP_10153 INDEX VALID
SYS_IOT_TOP_10156 INDEX VALID
SYS_LOB0000010136C00036$$ LOB VALID
SYS_LOB0000010137C00004$$ LOB VALID
WM$EVENT_AUX_PARAMS_NT TABLE VALID
WM$EVENT_QUEUE QUEUE VALID
WM$EVENT_QUEUE_N RULE SET VALID
WM$EVENT_QUEUE_R RULE SET VALID
WM$EVENT_QUEUE_TABLE TABLE VALID

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms