Is There Any Option Besides EIM Export Match IN Clause to Export Multiple But Not All Records of a Siebel Table? (Doc ID 2652978.1)

Last updated on MARCH 27, 2020

Applies to:

Goal

It is necessary to export thousands of attachments from the S_FILE_ATT table. The following ifb file was created:

[Export Attachment]
TYPE = EXPORT
BATCH = 2016
TABLE = EIM_FILE
EXPORT ALL ROWS = FALSE
EXPORT MATCHES = S_FILE_ATT,(ROW_ID IN('1-33YX','1-33Z5','1-33ZF'))

Is there a better solution for this case, so that multiple values are not written using the IN clause?
 

Solution

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