1. Oracle Fusion Middleware製品のオンプレミス・データベースからOracle Autonomous Transaction Processing (共有)データベースへのデータの移行
  2. 除外対象の表、パッケージおよびスキーマの統合リスト

C 除外対象の表、パッケージおよびスキーマの統合リスト

データベース移行サービス(DMS)を使用したOracle Autonomous Transaction Processing-Shared (ATP-S)データベース移行では、一部の表、パッケージおよびXMLスキーマをDMS移行ジョブから除外する必要があります。

DMSユーザー・インタフェースで除外する表、 パッケージおよびXMLスキーマの統合リスト

表C-1は、DMSユーザー・インタフェースで除外するオブジェクトのリストですが、これは、表B-1と表B-2のオブジェクトをまとめたリストです。

次の表名に「xxxxxx」が付いた除外対象の表については、「xxxxxx」を特定のスキーマ表名の数値に置き換えてください。

ノート:

"$"の付いた表を除外する場合は、バックスラッシュ(\)エスケープ文字を使用してください。たとえば、DR\$FT_IDCTEXT1\$Uです。

この表は、Oracle Fusion Middleware製品の情報の例を示しています(該当する場合)。必要な場合は、設定に基づいて追加のオブジェクトを指定してください。

表C-1 DMSユーザー・インタフェースで除外する表、パッケージおよびXMLスキーマの統合リスト

製品 除外対象の表 除外対象のパッケージおよびXMLスキーマ

Oracle Access Manager (OAM)

表:

メタデータ・サービス

MDS.MDS_PURGE_PATHS

NA

Oracle Identity Manager (OIM)

表:

メタデータ・サービス

MDS.MDS_PURGE_PATHS

ユーザー・メッセージング・サービス

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

パッケージ:

OIM

OIM.PIN_OBJ
OIM.PIN_SP

XMLスキーマ:

OIM

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

DMSユーザー・インタフェースで除外する場合は、次のように入力します:

アクション: Exclude

所有者: .*

名前: .*

オブジェクト型: 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

DMSユーザー・インタフェースで除外する場合は、次のように入力します:

アクション: Exclude

所有者: <schema_prefix>_edqstaging

名前: .*

オブジェクト型: ALL