Selectively load data using Oracle 11g r2 External Table Preprocessor
0
votes
1
answer
298
views
I am using the Preprocessor feature in Oracle 11g r2 to load several data files in a table. However, the raw files seem to have certain rows that shouldn't be imported with the rest. For example:
col1 col2 col3 col4
A 1 2 3
A 2 3 4
B ab bc cd
So, I want to only load the rows with col1 = 'A' and load the rows with col1 = 'B' into another table. How can I do this inside the processor?
Asked by sfactor
(111 rep)
Sep 15, 2014, 10:14 AM
Last activity: May 23, 2025, 06:04 AM
Last activity: May 23, 2025, 06:04 AM