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

Last updated on APRIL 09, 2024

Applies to:

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

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