processing very large file with util_file
Hi,
MY AIM IS TO LOAD THIS FILE INTO ORACLE TABLE
I have a file with inconsistent delimiters no specific tabs and with carriage return all over in the data, also some data columns contains (\t) as part of the data. When i try to load the file via sql loader it errors because lines are junks of data. If i use excel or .csv format the fields are scattered and mixed up in columns.
I was thinking of using UTIL_FILE break rows with CARRIAGE RETURN then concatenate to form meaning records,
what do you think???? thanks in advance.