|
by: gilgantic |
last post by:
Is there anyway of eliminating duplicate entries as the database loads data
using SQLLDR and/or .ctl (Control File)?
I use the following command line using SQLLDR and a control file to load my
data, but the sample.dat file has duplicate information. I would like to be
able to eliminate this, since I have know ability to manipulate the...
|
by: pargat singh |
last post by:
Hi Everyone
I am using SQLLDR to load the data and i am getting following error
SQL*Loader-908: Unable to lock table TABLE_NAME due to ORACLE
error 54.
Loader Cmd is
SQLLDR.EXE userid=XXXXX/YYYY@ZZZZ control=S:\.......\iss3_memdoc.ctl
|
by: vsarangiri |
last post by:
Is there a possibility to append in the bad file and discard file of a sqlldr instead of overwriting it. If so, how ?
|
by: vsarangiri |
last post by:
Is there a possibility to append in the bad file and discard file of a sqlldr instead of overwriting it. If so, how ?
|
by: dgalloway |
last post by:
can i validate a data field against an oracle validation table in the sqlldr process?
|
|
by: vshalpatel |
last post by:
Hi
I want to use SQL*Loader , an Oracle-supplied utility to load data from a flat file into one database tables.
for this I have write the scripts in the SQL*LOADER control file named loader.ctl. actual data file is mydata.csv that I have mentioned under ‘load data’ section in loader.ctl .
P.N : I am using my personal oracle installed ...
|
by: joe bolton |
last post by:
Can sqlldr append to a bad file instead of overwriting the file on every run?
|
by: Deshi |
last post by:
Hi All,
Is it possible to load data from client system to server system using
sqlldr command, i am trying to load nothing seems to be working for
me... any help would be helpful
|
by: faathir88 |
last post by:
How to execute sqlldr command in PHP??
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|