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

Last updated on NOVEMBER 02, 2010

Applies to:

Adverse Event Reporting System - Version: 4.6.0 and later   [Release: 4.6 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

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