Data load from DB2 table to Oracle table
Hi,
I have data file which contains DB2 table data. The requirement is to load that file into Oracle table. I am using SQL Loader utility. File has created using DB2 Export utility with column delimiter '0x19' and character delimiter '0x9' special character. I am aware of FIELD TERMINATED CLAUSE with in SQL Loader to provide Column delimiter.
Does SQL Loader provide functionality to read file with character delimiter ? if yes, which clause need to include in sql loader control file?
Thank you.