My Oracle Support Banner

Use Of Oracle 10g Datapump For Oracle Aers 4.6 Database (Doc ID 1254299.1)

Last updated on DECEMBER 04, 2019

Applies to:

Adverse Event Reporting System - Version 4.6.0 and later
Information in this document applies to any platform.

Goal



Want to use Oracle Datapump instead of the traditional export utility for our nightly logical backup of our
TMS 4.6 databases (with AERS) but it generates errors for following XMLSchema objects owned by TMS.

Is Oracle Datapump supported and do these tables contain permanent data used by the TMS application or are they temporary/transient data that is not crucial to the functioning of the application for backup/recover restoration.

select owner, table_name, column_name, data_type from dba_tab_columns where owner like 'TMS%' and data_type like '%XML%' order by 2;



TMS 4.6/AERS 4.6.1 returns:

 

TMS,ACTION_OWNER134_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,ACTION_OWNER244_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,ACTION_TEXT133_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,ACTION_TEXT243_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,APPROVED_FLAG132_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,APPROVED_FLAG242_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,CREATED_BY131_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,CREATED_BY241_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DEF_DETAIL_VALUE130_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DEF_DETAIL_VALUE240_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DICTIONARY_SHORT_NAME129_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DICTIONARY_SHORT_NAME239_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DICTIONARY_TERM128_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DICTIONARY_TERM238_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DOMAIN_NAME126_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,DOMAIN_NAME236_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,ERROR_ROW127_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,ERROR_ROW237_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_1124_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_1234_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_2123_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_2233_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_3122_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_3232_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_4121_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_4231_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_5120_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_5230_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_6119_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_6229_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_7118_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_7228_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_8117_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,EXT_VALUE_8227_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,GMT_DIFF116_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,GMT_DIFF226_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,INSTANCE_NAME115_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,INSTANCE_NAME225_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,INTEGRATION_KEY114_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,INTEGRATION_KEY224_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,LABEL_TEXT_UPPER125_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,LABEL_TEXT_UPPER235_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,OCCURRENCE_ID113_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,OCCURRENCE_ID223_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,OMISSION_STATUS112_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,OMISSION_STATUS222_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,SOURCE_TERM_ALT_KEY111_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,SOURCE_TERM_ALT_KEY221_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,SOURCE_TERM_ID110_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,SOURCE_TERM_ID220_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,STATUS109_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,STATUS219_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,TMSDSI101_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,TMSDSI211_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,TMS_DSI_XML_TMP,XMLTEXT,XMLTYPE
TMS,VERBATIM_TERM108_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VERBATIM_TERM218_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VTA_CREATED_BY106_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VTA_CREATED_BY216_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VTA_GLOBAL_FLAG105_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VTA_GLOBAL_FLAG215_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VT_SUBTYPE107_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,VT_SUBTYPE217_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,WARNING_ROW102_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,WARNING_ROW212_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,X_AREA104_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,X_AREA214_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,X_AREA_NAME103_TAB,SYS_NC_ROWINFO$,XMLTYPE
TMS,X_AREA_NAME213_TAB,SYS_NC_ROWINFO$,XMLTYPE

69 rows returned




Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.