Solved

SQL LOADER help

Posted on 2016-08-10
1
58 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
1 Comment
 
LVL 4

Accepted Solution

by:
Abhimanyu Suri earned 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

805 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