Need MAX Lob Size For DUP_SEARCH_DATA. Column defined as XMLTYPE) (Doc ID 2634406.1)

Last updated on JULY 13, 2023

Applies to:

Goal

Customer running 8.x and performing an automated database replication. One of the parameters is for the max size of a LOB field.

Is there an Argus limit to the maximum LOB size within table DUP_SEARCH_DATA for column case_data?

sql> describe DUP_SEARCH_DATA

Name Null? Type
---------------- -------- -------------------
CASE_ID NOT NULL NUMBER
CASE_DATA SYS.XMLTYPE
INIT_REPT_DATE DATE
PRODUCT_NAME VARCHAR2(1000 CHAR)
EVENT_NAME VARCHAR2(1000 CHAR)
REPORTER_NAME VARCHAR2(1000 CHAR)
EVENT_NAME_J VARCHAR2(1000 CHAR)
INIT_REPT_DATE_J DATE
PRODUCT_NAME_J VARCHAR2(1000 CHAR)
REPORTER_NAME_J VARCHAR2(1000 CHAR)
ENTERPRISE_ID NOT NULL NUMBER

Solution

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