My Oracle Support Banner

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

Last updated on JANUARY 30, 2020

Applies to:

Oracle Argus Safety - Version 8.0 to 8.2.1 [Release 8.0 to 8.2]
Information in this document applies to any platform.

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

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.