Top "Sql-loader" questions

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database.

SQL Loader script help with adding SYSDATE, USER

I'm trying to load data from a file and I want to set CREATED_DATE and UPDATED_DATE to SYSDATE …

sql oracle csv sql-loader controlfile
Oracle sqlldr timestamp format headache

I'm struggling to get sqlldr to import a csv data file into my table, specifically with the field that is …

oracle format timestamp sql-loader
sqlldr not found when using SQL*Loader in a shell script

I would like to create shell script, AUTOLOAD that will, when ran, execute SQL*Loader with a set of instructions. …

sql shell oracle-sqldeveloper sql-loader
How do you convert from scientific notation in Oracle SQL?

We are trying to load a file created by FastExport into an oracle database. However the Float column is being …

sql oracle sql-loader
load multiple csv into one table by SQLLDR

I am using SQL LOADER to load multiple csv file in one table. The process I found is very easy …

sql oracle sql-loader
SQL Loader Error: "Variable length field exceeds maximum length."

I have a SQL Loader Control file, LOAD DATA INFILE 'test.txt' INTO TABLE TEST replace fields terminated "|" optionally enclosed …

oracle sql-loader
Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?

Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus: sqlplus …

oracle sqlplus sql-loader tns
Convert date from one format to another using SQL*Loader control file

The data from the infile is in the format MM/DD/YYYY how do I tell the control file to …

sql oracle sql-loader
Install sql loader linux

I tried to install Oracle instant client on a redhat machine. I have instantClient basic, sdk, and sqlplus but I …

oracle oracle11g sql-loader
SQL*Loader-522: lfiopn failed for file

I am getting below error in my script which is running a SQLLDR : SQL*Loader-522: lfiopn failed for file (/home/…

bash shell oracle11g sql-loader