I\'m trying to load some data to an Oracle database using SQL Loader. Is it possible to 开发者_StackOverflow社区invoke it with specifying the server to load the data into using a DSN instead of a TNS?
I am using SQLloader in ASP.NET appliaction to automate the bulk upload data to oracle db from CSV/EXCEL.
I\'m struggling to get sqlldr to import a csv data file into my table, specifically with the field that is a timestamp.
How do I access the input data file name from within SQL*Loader control file so that I can insert it into the table along with data from the input file?
I am getting an error SQL*Loader-606, which means: The synonym specified in the INTO TABLE clause in the SQL*Loader control