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.

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
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`