How Many Characters Can be put into an Archiver Custom Export Query String? (Doc ID 1592930.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

Have about 11K non-contiguous records that need to be exported using the Archiver tool.

Need to create a query string to export multiple individual records in the Archiver tool, but it is unknown what the maximum limit of how many values can be entered into the query. i.e. dDocName in ('Value1','Value2','Value3',...'ValueN').

Example of what is required to Export
----------------------------------------------------------
(Revisions.dDocName = 'BC1005290' AND Revisions.dRevLabel = '3') OR
(Revisions.dDocName = 'BC1005333' AND Revisions.dRevLabel = '2') OR
(Revisions.dDocName = 'BC1005387' AND Revisions.dRevLabel = '2') OR
(Revisions.dDocName = 'BC1005576' AND Revisions.dRevLabel = '2') OR

Essentially there is in this example, there is about 11.6 thousand rows of the above to run.

Question:  How many characters can be put into an Archiver Custom Export Query string, as described above ?
 

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