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.

Message 2100 when run sql*loader from UNIX

I have .sh file with the next content: #!/bin/bash echo -------- uploader.sh v 0.1 -------- ORACLE_HOME=/opt/app/…

bash unix sql-loader
Oracle Sql Loader "ORA-01722: invalid number" when loading CSV file with Windows line endings

I am using Oracle Sql Loader Utility from Linux shell to load csv data into Oracle DB. But I have …

oracle sql-loader
Update a column in table using SQL*Loader?

I have written a SQL Script having below query. Query works fine. update partner set is_seller_buyer=1 where id …

sql oracle sql-loader
ORA delete / truncate

I'm using SQL loader to load my data into database. Before I insert the data I need to remove existing …

sql oracle truncate sql-loader
Load data from csv file to oracle table from command line

I tried with sql loader.The thing is the table needs to be empty for data loading.Is there any …

oracle oracle11g sql-loader data-import
sql loader- files with carriage return, line feed load into oracle with cr/lf

I have data extract from sql server where data in most columns have carriage return and line feeds. I need …

sql-server oracle oracle11g sql-loader
How to import "loader" format data using SQLDeveloper?

How do I import data in "loader" format using SQL Developer? SQLDeveloper can export data in "loader" format, so I …

import oracle-sqldeveloper sql-loader
SQL loader installation

How can I install the SQL Loader, when I have installed the Oracle Data Access Components(ODAC) for windows? I …

oracle sql-loader oracleclient
Oracle SQL Loader - How to not display "Commit point reached - logical record count" counts

I'm loading big files via Oracle SQL Loader over vpn from home, and they're taking a lot of time. They …

sql oracle loader sql-loader