PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
11 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL LOADER help
Posted on 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
)
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
)
[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
Active today
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
Hopefully it will help you too, thanks to the author :)
https://www.safaribooksonline.com/library/view/oracle-parallel-processing/156592701X/ch04s04.html
Featured Post
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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
* Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 13 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.