1. Migrating Data for Oracle Fusion Middleware Products from On-Premises to ATP-S Database
  2. Consolidated List of Excluded Tables, Packages, and Schemas

C Consolidated List of Excluded Tables, Packages, and Schemas

In Oracle Autonomous Transaction Processing-Shared (ATP-S) database migration using Database Migration (DMS) service, some tables, packages, and XML schemas need to be excluded from the DMS migration job.

Consolidated List of Tables, and Packages and XML Schemas to Exclude in DMS User Interface

Table C-1 provides the list of objects to be excluded in the DMS user interface, which is the consolidated list of objects in Table B-1 and Table B-2.

For excluded tables listed with "xxxxxx"in their table name below, replace "xxxxxx" with the numeric value in your specific schema table name.

Note:

When excluding tables with "$", use the backslash (\) escape character. For example, DR\$FT_IDCTEXT1\$U.

The table provides sample information for the Oracle Fusion Middleware products, wherever applicable. Based on your setup, provide any additional objects, if required.

Table C-1 Consolidated List of Tables, and Packages and XML Schemas to Exclude in DMS User Interface

Product Excluded Tables Excluded Packages and XML Schemas

Oracle Access Manager (OAM)

Tables:

Metadata Services

MDS.MDS_PURGE_PATHS

NA

Oracle Identity Manager (OIM)

Tables:

Metadata Services

MDS.MDS_PURGE_PATHS

User Messaging Service

UMS.ORASDPMENGINERCVT1
UMS.ORASDPMWSRCVT1
UMS.ORASDPMDRIVERDEFSNDT1
UMS.ORASDPMENGINEPENDRCVQT
UMS.ORASDPMAPPDEFRCVT1
UMS.ORASDPMENGINECMDT
UMS.ORASDPMENGINESNDT

SOAINFRA

SOAINFRA.TEMP_CUBE_INSTANCE_GLB
SOAINFRA.TEMP_DOCUMENT_CI_REF_GLB
SOAINFRA.TEMP_DOCUMENT_DLV_MSG_REF_GLB
SOAINFRA.TEMP_BRDECISION_INSTANCE_GLB
SOAINFRA.TEMP_WFTASK_PURGE_GLB
SOAINFRA.TEMP_MEDIATOR_DEFERRED_GLB
SOAINFRA.TEMP_MEDIATOR_RESEQUENCER_GLB
SOAINFRA.TEMP_FLOWID_PURGE_GLB
SOAINFRA.B2B_BAM_QTAB
SOAINFRA.RUPD$_MFT_DATA_STORAGE
SOAINFRA.OSB_FTP_TRANSPORT_TBL
SOAINFRA.OSB_SFTP_TRANSPORT_TBL
SOAINFRA.OSB_EMAIL_TRANSPORT_TBL
SOAINFRA.AIA_CAVSCALLBACKJMSQTAB
SOAINFRA.OSB_PURGE_TBL
SOAINFRA.OSB_FILE_TRANSPORT_TBL
SOAINFRA.OSB_REPORTING_TBL
SOAINFRA.OSB_REPORTING_ERROR_TBL
SOAINFRA.IP_QTAB
SOAINFRA.AQ$_IP_QTAB_S
SOAINFRA.AQ$_IP_QTAB_T
SOAINFRA.AQ$_IP_QTAB_H
SOAINFRA.AQ$_IP_QTAB_L
SOAINFRA.AQ$_IP_QTAB_G
SOAINFRA.AQ$_IP_QTAB_I
SOAINFRA.EDN_EVENT_QUEUE_TABLE
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_S
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_T
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_H
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_L
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_G
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_I
SOAINFRA.EDN_OAOO_DELIVERY_TABLE
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_S
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_T
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_H
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_L
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_G
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_I
SOAINFRA.EDN_AQJMS_TOPIC_TABLE
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_S
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_T
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_H
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_L
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_G
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_I
SOAINFRA.TASK_NOTIFICATION_Q_T
SOAINFRA.RUPD$_MFT_SOURCE_MESSAGE
SOAINFRA.RUPD$_MFT_TRANSFER_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_MESSAGE
SOAINFRA.UPGRADE_CURRENT_SEQUENCE_TEMP
SOAINFRA.TEMP_UPGRADE_ECID
SOAINFRA.TEMP_UPGRADE_CI
SOAINFRA.TEMP_UPGRADE_DLV_MSG
SOAINFRA.TEMP_UPGRADE_DLV_ECID_MAP
SOAINFRA.TEMP_UPGRADE_WKITM_CI
SOAINFRA.TEMP_UPGRADE_WFTASK
SOAINFRA.TEMP_UPGRADE_BRDECISION
SOAINFRA.TEMP_UPGRADE_MI
SOAINFRA.TEMP_UPGRADE_MCI
SOAINFRA.TEMP_UPGRADE_MCDV
SOAINFRA.TEMP_UPGRADE_CPST_INST
SOAINFRA.SYS_IOT_OVER_xxxx
SOAINFRA.SYS_IOT_OVER_xxxx
SOAINFRA.SYS_IOT_OVER_xxxx
SOAINFRA.SYS_IOT_OVER_xxxx

Oracle Identity Manager

OIM.DR$CAT_TAGS$I
OIM.DR$CAT_TAGS$K
OIM.DR$CAT_TAGS$N
OIM.DR$CAT_TAGS$U
OIM.DR$CAT_TAGS$S
OIM.OIM_TMP_MLS_TABLE
OIM.OIM_TMP_RECON_MLS_TABLE
OIM.COUN_LOG_TAB
OIM.TEMP_REC_TABLE
OIM.TEMP_REC_TAB
OIM.TEMP_REC_TAB_1
OIM.TEMP_REC_TAB_2
OIM.TEMP_REC_DYNAMIC
OIM.TEMP_TABLE
OIM.TEMP_TABLES_TO_DROP
OIM.TEMP_ORGANIZATION_USERS
OIM.CATALOG_HIERARCHICAL_ATTR_EVAL
OIM.ORG_AVAILABLE_ROLES
OIM.RECON_ACCOUNT_OLDSTATE
OIM.RECON_UGP_OLDSTATE
OIM.RECON_USER_OLDSTATE
OIM.REQUEST_ENTITY_ATTR_VALUES
OIM.CATALOG_HIERARCHICAL_ATTR

Packages:

OIM

OIM.PIN_OBJ
OIM.PIN_SP

XML Schemas:

OIM

http://localhost/public/xsd/hierarchicalEntitlement.xsd

When excluding in the DMS user interface, enter as:

Action: Exclude

Owner: .*

Name: .*

Object type: XMLSCHEMA

SOA/Oracle Business Process Management

 
SOAINFRA.AIA_CAVSCALLBACKJMSQTAB
SOAINFRA.IP_QTAB
SOAINFRA.AQ$_IP_QTAB_S
SOAINFRA.AQ$_IP_QTAB_T
SOAINFRA.AQ$_IP_QTAB_H
SOAINFRA.AQ$_IP_QTAB_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_IP_QTAB_G
SOAINFRA.AQ$_IP_QTAB_I
SOAINFRA.EDN_EVENT_QUEUE_TABLE
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_S
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_T
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_H
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_G
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_I
SOAINFRA.EDN_OAOO_DELIVERY_TABLE
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_S
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_T
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_H
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_G
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_I
SOAINFRA.EDN_AQJMS_TOPIC_TABLE
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_S
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_T
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_H
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_G
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_I
SOAINFRA.TASK_NOTIFICATION_Q_T
SOAINFRA.RUPD$_MFT_SOURCE_MESSAGE
SOAINFRA.RUPD$_MFT_TRANSFER_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_MESSAGE
SOAINFRA.RUPD$_MFT_DATA_STORAGE
SOAINFRA.OSB_FTP_TRANSPORT_TBL
SOAINFRA.OSB_SFTP_TRANSPORT_TBL
SOAINFRA.OSB_EMAIL_TRANSPORT_TBL
SOAINFRA.OSB_FILE_TRANSPORT_TBL
SOAINFRA.OSB_REPORTING_TBL
SOAINFRA.OSB_REPORTING_ERROR_TBL
SOAINFRA.OSB_PURGE_TBL
SOAINFRA.TEMP_FLOWID_PURGE_GLB
SOAINFRA.TEMP_CUBE_INSTANCE_GLB
SOAINFRA.TEMP_DOCUMENT_CI_REF_GLB
SOAINFRA.TEMP_DOCUMENT_DLV_MSG_REF_GLB
SOAINFRA.TEMP_BRDECISION_INSTANCE_GLB
SOAINFRA.TEMP_WFTASK_PURGE_GLB
SOAINFRA.TEMP_MEDIATOR_DEFERRED_GLB
SOAINFRA.TEMP_MEDIATOR_RESEQUENCER_GLB
SOAINFRA.UPGRADE_CURRENT_SEQUENCE_TEMP
SOAINFRA.TEMP_UPGRADE_ECID
SOAINFRA.TEMP_UPGRADE_CI
SOAINFRA.TEMP_UPGRADE_DLV_MSG
SOAINFRA.TEMP_UPGRADE_DLV_ECID_MAP
SOAINFRA.TEMP_UPGRADE_WKITM_CI
SOAINFRA.TEMP_UPGRADE_WFTASK
SOAINFRA.TEMP_UPGRADE_BRDECISION
SOAINFRA.TEMP_UPGRADE_MI
SOAINFRA.TEMP_UPGRADE_MCI
SOAINFRA.TEMP_UPGRADE_MCDV
SOAINFRA.TEMP_UPGRADE_CPST_INST
SOAINFRA.B2B_BAM_QTAB
SOAINFRA.CLUSTER_NODE
PROCOBJ

NA

SOA/Oracle Business Activity Monitoring (BAM) 

SOAINFRA.AIA_CAVSCALLBACKJMSQTAB
SOAINFRA.IP_QTAB
SOAINFRA.AQ$_IP_QTAB_S
SOAINFRA.AQ$_IP_QTAB_T
SOAINFRA.AQ$_IP_QTAB_H
SOAINFRA.AQ$_IP_QTAB_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_IP_QTAB_G
SOAINFRA.AQ$_IP_QTAB_I
SOAINFRA.EDN_EVENT_QUEUE_TABLE
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_S
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_T
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_H
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_G
SOAINFRA.AQ$_EDN_EVENT_QUEUE_TABLE_I
SOAINFRA.EDN_OAOO_DELIVERY_TABLE
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_S
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_T
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_H
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_G
SOAINFRA.AQ$_EDN_OAOO_DELIVERY_TABLE_I
SOAINFRA.EDN_AQJMS_TOPIC_TABLE
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_S
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_T
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_H
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_L
SOAINFRA.SYS_IOT_OVER_xxxxx
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_G
SOAINFRA.AQ$_EDN_AQJMS_TOPIC_TABLE_I
SOAINFRA.TASK_NOTIFICATION_Q_T
SOAINFRA.RUPD$_MFT_SOURCE_MESSAGE
SOAINFRA.RUPD$_MFT_TRANSFER_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_INSTANCE
SOAINFRA.RUPD$_MFT_TARGET_MESSAGE
SOAINFRA.RUPD$_MFT_DATA_STORAGE
SOAINFRA.OSB_FTP_TRANSPORT_TBL
SOAINFRA.OSB_SFTP_TRANSPORT_TBL
SOAINFRA.OSB_EMAIL_TRANSPORT_TBL
SOAINFRA.OSB_FILE_TRANSPORT_TBL
SOAINFRA.OSB_REPORTING_TBL
SOAINFRA.OSB_REPORTING_ERROR_TBL
SOAINFRA.OSB_PURGE_TBL
SOAINFRA.TEMP_FLOWID_PURGE_GLB
SOAINFRA.TEMP_CUBE_INSTANCE_GLB
SOAINFRA.TEMP_DOCUMENT_CI_REF_GLB
SOAINFRA.TEMP_DOCUMENT_DLV_MSG_REF_GLB
SOAINFRA.TEMP_BRDECISION_INSTANCE_GLB
SOAINFRA.TEMP_WFTASK_PURGE_GLB
SOAINFRA.TEMP_MEDIATOR_DEFERRED_GLB
SOAINFRA.TEMP_MEDIATOR_RESEQUENCER_GLB
SOAINFRA.UPGRADE_CURRENT_SEQUENCE_TEMP
SOAINFRA.TEMP_UPGRADE_ECID
SOAINFRA.TEMP_UPGRADE_CI
SOAINFRA.TEMP_UPGRADE_DLV_MSG
SOAINFRA.TEMP_UPGRADE_DLV_ECID_MAP
SOAINFRA.TEMP_UPGRADE_WKITM_CI
SOAINFRA.TEMP_UPGRADE_WFTASK
SOAINFRA.TEMP_UPGRADE_BRDECISION
SOAINFRA.TEMP_UPGRADE_MI
SOAINFRA.TEMP_UPGRADE_MCI
SOAINFRA.TEMP_UPGRADE_MCDV
SOAINFRA.TEMP_UPGRADE_CPST_INST
SOAINFRA.B2B_BAM_QTAB
SOAINFRA.CLUSTER_NODE
PROCOBJ

NA

Oracle Enterprise Scheduler (ESS) 

ESS.ESS_TEMP_REQID
PROCOBJ

NA

Oracle Managed File Transfer (MFT) 

MFT.RUPD$_MFT_SOURCE_MESSAGE
MFT.RUPD$_MFT_TRANSFER_INSTANCE
MFT.RUPD$_MFT_TARGET_INSTANCE
MFT.RUPD$_MFT_TARGET_MESSAGE
MFT.RUPD$_MFT_DATA_STORAGE

NA

Oracle Enterprise Data Quality

(EDQ) 
EDQ_STAGING

When excluding in the DMS user interface, enter as:

Action: Exclude

Owner: <schema_prefix>_edqstaging

Name: .*

Object type: ALL