?
Solved

SQL LOADER help

Posted on 2016-08-10
1
Medium Priority
?
84 Views
Last Modified: 2016-08-10
Hi Team,

I have created  the below control file for loading mutliple files at one shot using SQL LOADER , this script I have taken from one of the blog on sql loader.
My Question is  
1. does SQL LOADER load all the 3 files simultaneously into the target table daily upload , if so how this processing happens and how many files does SQL LOADER read at a time and also the rows
2. Impact on the indexes if any.
 

load data
infile 'data_daily1.csv'
infile 'data_daily2.csv'
infile 'data_daily3.csv'
append
into table daily_upload
fields terminated by ","
optionally enclosed by '"'
trailing nullcols
(
col1,
col2,
col3,
col4,
col5
)
0
Comment
Question by:sam_2012
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
Abhimanyu Suri earned 2000 total points
ID: 41751178
Fortunately, I had below mentioned link available in my repository
Hopefully it will help you too, thanks to the author :)

https://www.safaribooksonline.com/library/view/oracle-parallel-processing/156592701X/ch04s04.html
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question