. If you can't get to the IOUG web site and
would like a copy of the paper, send me an email.
David Scott
[EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Thu, 11 Sep 2003 14:12:49 +0200
Subject: Sqlloader question
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write for instance this
if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'
If there are going to be files with different extensions fo rinstance the first time a
file is going
: Thursday, September 11, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write for
instance this if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'
If there are going to be files
/MEY/NL)
.comSubject: Sqlloader 8.1.7.4 problem
Sent
Hello everyone,
I am having a problem with sqlloader version 8.1.7.4 on HP-UX. I am trying
to load a 13mb file that does not contain carriage returns. When I run it in
sqlloader I receive the following:
SQL*Loader-500: Unable to open file (/usr/local/bell_logix/tax/SEQMAST.dat)
SQL*Loader-555
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader
I loaded 20 000 lines in 1 minute and I wish to load 400 000 lines in the
same time?
--
Please see
Hi,
Network performance could be a bottleneck.
Do you run loader from server or from remote host?
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:58 PM
How can I do to sqlloader work faster.
I tryed the DIRECT
U can set the Buffer size to increase the work faster
-Original Message-
Sent: Tuesday, July 30, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am
AM
To: Multiple recipients of list ORACLE-L
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader
I loaded 20 000 lines in 1 minute and I wish to load 400 000 lines
at
http://oracle.oreilly.com/news/oraclesqlload_0401.html
HTH
John
-Original Message-
Sent: 30 July 2002 13:59
To: Multiple recipients of list ORACLE-L
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am
]
-Original Message-
Sent: Tuesday, July 30, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L
How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader
I
: Alexandre Gorbatchev
[mailto:[EMAIL PROTECTED]]
Date: mardi 30 juillet 2002 16:03
À: Multiple recipients of list ORACLE-L
Objet: Re: Faster Sqlloader Question
Hi,
Network performance could be a bottleneck.
Do you run loader from server
Sqlloader Question
Hi,
Network performance could be a bottleneck.
Do you run loader from server or from remote host?
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:58 PM
How can I do to sqlloader work
Hi,
I asked recently how to provide nls_date_language within sqlloader config
file.
[EMAIL PROTECTED] provided the solution:
specify for the date column:
...
date_col to_date(rtrim('Jan 15 1989 11:00:000AM',':000AM'),'Mon dd
hh:mi:ss','NLS_DATE_LANGUAGE = American'),
...
Antje Sackwitz
Hi,
I have to load an ASCII dump into Oracle with loader that contains date
information in a different national character set than my databse.
Can I specify a different nls_lang ( Do an alter session set =
nls_lang...)
before the load?
If so, can you please give me the syntax?
Regards,
Antje
BDY.RTF
Description: RTF file
Hi,
I want to precice my question on SQLLoader and date format:
I want to give my date field a special nls_date_language.
Can Anyone help with the syntax?
Regards,
Antje Sackwitz
Antje Sackwitz
ppi Media GmbH
Deliusstraße 10
D-24114 Kiel
phone +49 (0) 43 1
BDY.RTF
Description: RTF file
Yes I know.
But how is the syntax with loader?
Can I provide the information in the controlfile?
i found a possibility to set NLS_DATE_LANGUAGE BEFORE calling the
sqlloader, but how is the syntax in the
controlfile in following line
Date_field date 'Mon dd hh:mi:ss' RTRIM(:Date_date
Hallo, anyone whom can help me with this:
I am running sqllodaer and gets this errormessage in the log:
Record 18729: Rejected - Error on table RIK2.IMP_NIELSEN, column MONTH_DISTR_W
Column not found before end of logical record (use TRAILING NULLCOLS)
ORA-01631: max # extents (20) reached in
Hi,
Not used SQLLOADER much but it seems that your controlfile says there
should be a column named month_distr_w that is not in your data.
How to fix it:
If your sure the column is in the data check your controlfile for other
syntax errors. If the column is not in the data than the answer
Roland,
Looks like your table run out of space and cannot be extended. The
workaround - pre-create table bigger (that's better) or set max extents
higher.
Strange that Loader complains about input file. It went crazy probably.
You don't need TRAILING NULLCOLS if you have all columns in each
The error message indicates that the current maxextents value for table IMP_NIELSEN is
20 and this number of extents had been reached during the load. Since there was still
more data to load and Oracle tried to get to the next extent but
could not since it had already reached the max value.
read the documentation, start in the errors manual and the utilities manual.
[EMAIL PROTECTED] wrote:
Hallo, anyone whom can help me with this:
I am running sqllodaer and gets this errormessage in the log:
Record 18729: Rejected - Error on table RIK2.IMP_NIELSEN, column MONTH_DISTR_W
Column
Hi all,
Can any one please tell me what is the deciding factor
to specify rows value and bindsize value in sqlloader
option?
is there any option to use direct=true while using
function in control file?
DB:8.1.7 os:SUN SS
thanks for your help.
Cheers,
Ravi
is the deciding factor
to specify rows value and bindsize value in sqlloader
option?
is there any option to use direct=true while using
function in control file?
DB:8.1.7 os:SUN SS
thanks for your help.
Cheers,
Ravi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
buffer bytes: 976
HTH,
Beth
-Original Message-
Sent: Wednesday, June 26, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Can any one please tell me what is the deciding factor
to specify rows value and bindsize value in sqlloader
option?
is there any option
recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 9:08 AM
Hi all,
Can any one please tell me what is the deciding
factor
to specify rows value and bindsize value in
sqlloader
option?
is there any option to use direct=true while
using
function
Typing on a keyboard can accomplish this.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader
Hallo,
Anyone whom
[EMAIL PROTECTED] wrote:
Typing on a keyboard can accomplish this.
Scott Shafer
San Antonio, TX
210-581-6217
Can you give an example of how to type on a keyboard ? The Oracle
manuals are unclear on this.
TIA.
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ:
First, take a hammer
Stephane Faroult wrote:
Can you give an example of how to type on a keyboard ? The Oracle
manuals are unclear on this.
TIA.
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET:
Then place your thumb squarely atop the fine manual...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Suzy Vordos [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Sqlloader
First
Looking for a way in Unix to pass a variable into a Sqlloader control, and
then use that as a constant. Database version is 7.3.4
I tried something like:
control file ---
$1 = filename
.
.
.
.
.
SOURCE_FILE CONSTANT $SOURCE_FILE
.
.
.
When running, I
CONSTANT $1
control.ctl
then run sqlloader using the control file you created.
make sense?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, May 28, 2002 3:55 PM
To: Multiple recipients of list ORACLE-L
Looking for a way in Unix
Hello,
Env: Oracle 8.1.6.0.0 on Solaris 2.7
Does anyone know what controls sqlloader behaviour regarding the
number of records it rejects when an error is encountered?
We have a number of daily sqlldr processes; this morning, one
sqlldr process rejected 7 records because of unique constraint
Oracle got back to me (very promptly) regarding the rejection
of several records by sqlloader when only one record in the
batch had an error.
The short answer is that the violated PK constraint, unlike
all others, had been created as DEFERRED.
From Metalink:
**( Source
Title: RE: Sqlloader
See the following note sent on 4/12/01 - it should assist
John
Try the following example:
TMD=`date '+%Y/%m/%d'`
TMS=`date '+%Y%m%d%H%M%S'`
sqlplus -s internal whisky
set verif off pages 0 echo off feed off term off lines 200
spool $SHELLSRCDIR/dbcontents
Professional
-Original Message-
Sent: Thursday, December 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
I need to load a text format file into my database using sqlloader. The
table I am loading into contains a special code column 9 positions long
with a following format
I need to load a text format file into my database using sqlloader. The
table I am loading into contains a special code column 9 positions long
with a following format ##--###--## (note dashes in between). Dashes are
being stored in the database! (don't ask me why :-) ). My input file data
Have a look at the section in sql loader on applying SQL to fields in theSLQ Loader documents
else
Is it possible for you to run the data through a Perl script to alter tha data before invoking sqlloader
Cheers
--
=
Peter McLartyE-mail
Title: SqlLoader
Stupid
question I know but is the correct SID set ??
and
watch out for TWO_TASK !!
Regards
Lee
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001
6:10 AMTo: Multiple recipients of list ORACLE-LSubject
Title: SqlLoader
Hey,
at this point nothing is stupid. The problem is probably something
'stupid' that I am or are not doing. Yes, I did try setting the Oracle_sid
parameter when I started trying to figure out what was
wrong.
Now
for my stupid question. What is Two_Task?
Thanks,
Laura
Laura,
We use a particular id/passwd to load the data using sqlloader. The xx.PAR file
contains the userid and password along with the connect string to connect to the
database.
ex:
sqlldr parfile=path/name.PAR
name.par displays
Userid=loadit/loadpasswd@connect string
other commands...
Has
Title: SqlLoader
TWO_TASK
Function
Sets the default Net8
connect string descriptor alias defined in the tnsnames.ora
file
Is
this set maybe ??
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED
Title: SqlLoader
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001
2:35 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SqlLoader
Hey,
at this point nothing is stupid. The problem is probably something
Title: SqlLoader
two_task is an environment variable that you can set
for the "default" Net8 connection so users don't have to put
"@gobbledeegoop.companyname.domain.com" after their password.
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTE
,
Jeff
Tempe, AZ
- Original Message -
To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L
Sent: Wednesday, December 12, 2001 3:35 PM
I have never had a problem with sqlloader before, but now when I run it
I
get an error 'invalid name/password' message. I can sign
Title: SqlLoader
Hope you have checked the SID.. and also check
whether LD_LIBRARY_PATH is set or not..
Make a FREE long distance call from
your PC!http://www.eboom.com/free/
- Original Message -
From:
Burton,
Laura L.
To: Multiple
Title: SqlLoader
I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems.
Any ideas?
Thanks,
Laura
Title: SqlLoader
Laura,
The username that you are trying to use, does this
username own the table that is to be loaded, or does this username have DBA
privileges?
Even though you can connectvia sqlplus and/or
svrmgr to a session, this does not mean that you willbe able to load data
Title: SqlLoader
Thank
you for your reply. The user does have DBA rights and also owns the table
that is being referenced. If it was a table rights issue I would think I
would have gotten 'table or view does not exist' message. I don't think it
is even getting connected to the
database
Hei..friend...need some help over here.
Will mainframe system able to read our sqlloader text file directly ? as
VSAM format?
if not how can I convert it to VSAM format ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raymond
INET: [EMAIL PROTECTED]
Fat City
:
ate.ny.us Subject: RE: Sqlloader - important
Sent by:
[EMAIL PROTECTED]
11/13/2001 10:40
AM
Please respond
to ORACLE-L
You are missing a comma and another
What does your data file (sorry infile) look like ??
-Original Message-
Sent: 13 November 2001 19:17
To: Multiple recipients of list ORACLE-L
Hallo,
I am running this sqlloader ctl-file
load data
infile 'C:\temp\arg\argdwfkt3.txt'
TRUNCATE
into table argdwfkt_kopia
FIELDS
this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, November 13, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L
Hallo all you DBA's
How do I write in sqlloader if i want to replace, translate the caracter ?
with 'No info
Why does this sqlloader ctl file giveme this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED BY ';'
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID),
KAMPANJTYP_NAMN)
SQL*Loader
: Tuesday, November 13, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Why does this sqlloader ctl file give me this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED BY ';'
(KAMPANJTYP_ID DECODE
Title: RE: Sqlloader - important
I think the problem lies in the fact your missing a comma and a single quote:
DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)
shouldn't that be: DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID) ?
Later, Ivan
-Original Message-
From
Come on Roland, look at your code closely, especially in the area of the
exclamation mark. This really is too easy (and I've given you a large hint
!!).
-Original Message-
Sent: 13 November 2001 15:45
To: Multiple recipients of list ORACLE-L
Hallo,
Why does this sqlloader ctl file
Message-
Sent: Tuesday, November 13, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Why does this sqlloader ctl file give me this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED
, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Why does this sqlloader ctl file give me this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED BY ';'
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Sqlloader - important
om
There is an extra quote (').
'98'!'
Why is the '!' there ??
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID),
KAMPANJTYP_NAMN)
-Original Message-
Sent: Tuesday, November 13, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
Why does this sqlloader ctl
] Subject: Sqlloader - important
om
To: Multiple recipients of list ORACLE-L
@ica.se [EMAIL PROTECTED]
Sent by: rootcc:
Subject: Sqlloader
It looks like you have a ' missing check ,'98'!', there is one too few.
Cheers,
Kev.
-Original Message-
Sent: 13 November 2001 15:20
To: Multiple recipients of list ORACLE-L
Why does this sqlloader ctl file giveme this errormessage?
the control file looks like:
load data
infile
] Subject: Sqlloader - important
om
2001.11.13
17:45
Please respond
to ORACLE-L
Hallo,
Why does this sqlloader ctl file give me this errormessage?
the control file looks like
Hallo,
I am running this sqlloader ctl-file
load data
infile 'C:\temp\arg\argdwfkt3.txt'
TRUNCATE
into table argdwfkt_kopia
FIELDS TERMINATED BY ';'
(BUTIKS_ID,
BUT_NAMN,
REGION_ID DECODE(:REGION_ID,'!','98','?','97',:REGION_ID),
DISTRIKT_ID DECODE(:DISTRIKT_ID,'!','98','?','97
]
Sent: Tuesday, November 13, 2001 2:17 PM
Hallo,
I am running this sqlloader ctl-file
load data
infile 'C:\temp\arg\argdwfkt3.txt'
TRUNCATE
into table argdwfkt_kopia
FIELDS TERMINATED BY ';'
(BUTIKS_ID,
BUT_NAMN,
REGION_ID DECODE(:REGION_ID,'!','98','?','97',:REGION_ID),
DISTRIKT_ID DECODE
:
ate.ny.us Subject: RE: Sqlloader - important
Sent by:
[EMAIL PROTECTED
Hello
,
I have a small
problems because of empty fields and NULL fields.
I have a data file
extracted from a non-Oracle DB where the empty field is represented by a single
space char and NULL field is represented with nothing , ||| is field delimitor ,
#|# is line delimitor
toto|||
Title: RE: misunderstanding between DEFAULTIF and NULLIF with SQLLOader
I have to ask, what's the difference between an empty field and a null field to you? Empty is the same as null to me - undefined.
That's the whole reason for the NULLIF keyword. Make spaces null prior to insert.
You
Hallo all you DBA's,
Can anyone give me some examples on how to do this:
I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from
a text file, immediately, after the insert into tthe table, there will be an insert
into another table(TABLE2) with data from TABLE1
123,20010920,20,30,35
123,20010920,20,30,35
Regards,
Nirmal.
-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQLLOADER question.
Ron,
try this:
Load data
the book.
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
-Original Message-
Sent: Friday, September 21, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
List,
Oracle 7.3.4
Using SqlLoader I load a table with 5 columns of data. I would like to be
able to have column
it - works fine!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 21, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
List,
Oracle 7.3.4
Using SqlLoader I load a table with 5 columns of data. I would like to be
able to have column 4
Title: RE: sqlloader-bad file
Try the folling as the calling file load.sh (chmod 555 or similar before running)
sqlldr control=ABS_Load.ctl log=abs.log bad=abs.bad userid=user/pwd rows=2 bindsize=500 direct=true errors=5000
John
-Original Message-
From: [EMAIL PROTECTED
you don't put it in the control file. When you run sqlldr, just as you have
control=filename you add log=logfilename and it will write to the
logfile
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: sqlloader-bad file
Date
:37 PM
To: Multiple recipients of list ORACLE-L
Silly ol' me. Are you out of space in your archive log destination?
This is like a guessing game. :-)
[EMAIL PROTECTED] wrote:
Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader
one server that is givingme a hard
time. It loads 3 files and then stops. I commented out
thethird call to sqlloader thinking may be
there is something wrong with a thirdtext file. It
loaded 3 files again and stopped on the forth one. There is
nothing in alert log (no errors). Also, there is e
one after
another.
Thanks for your
interest...
-Original Message-From: Stephen Andert
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08,
2001 1:17 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: sqlloader stops
Lyuda,
I'll jump intothe game of 20
another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.
It
works fine on other servers. There is this one server that is giving
me a
hard time. It loads 3 files and then stops. I commented out the
third
call
to sqlloader thinking may
Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader. It
works fine on other servers. There is this one server that is giving me a
hard time. It loads 3 files and then stops. I commented out the third call
to sqlloader thinking may
To: Multiple recipients of list ORACLE-L
Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader. It
works fine on other servers. There is this one server that is giving me a
hard time. It loads 3 files and then stops. I commented out the third call
problem.
I have a process that loads multiple (~ 20 ) files through sqlloader. It
works fine on other servers. There is this one server that is giving me a
hard time. It loads 3 files and then stops. I commented out the third call
to sqlloader thinking may be there is something wrong with a third
Silly ol' me. Are you out of space in your archive log destination?
This is like a guessing game. :-)
[EMAIL PROTECTED] wrote:
Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader. It
works fine on other servers. There is this one server
have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader. It
works fine on other servers. There is this one server that is giving me a
hard time. It loads 3 files and then stops. I commented out the third
call
to sqlloader thinking may be there is something
, 2001 5:37 PM
To: Multiple recipients of list ORACLE-L
Silly ol' me. Are you out of space in your archive log destination?
This is like a guessing game. :-)
[EMAIL PROTECTED] wrote:
Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader
-Sent: Tuesday, July 31, 2001 3:42 PMTo: Multiple recipients
of list ORACLE-LHi,I am experiencing a problem with sqlloader
not being able to finish a largeload. It tries to load between 1 and 2
millions records. Sometime duringthe load it just dies. I see an
attempt to create a log file
Since it can't create a log file either ... how about space ??? running out
of space on the machine ??
-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load
??
-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load. It tries to load between 1 and 2 millions records. Sometime during
the load it just dies. I see an attempt to create
a problem with sqlloader not being able to finish a large
load. It tries to load between 1 and 2 millions records. Sometime during
the load it just dies. I see an attempt to create a log file but the file
size remains 0 bytes. It remains 0 size until the next day when new process
kicks off
out
of space on the machine ??
-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load. It tries to load between 1 and 2 millions records. Sometime during
it can't create a log file either ... how about space ??? running out
of space on the machine ??
-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load
PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject: sqlloader question
Hello oradba's,
I have a general question about sqlloader.
There is an option called ROWS. According to Oracle Complete
reference by
G.Koch
of a failure. It's all a
tradeoff.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, July 03, 2001, 1:02:25 PM, you wrote:
lcc Hello oradba's,
lcc I have a general question about sqlloader.
lcc
Acxiom Ltd
Tel: +44 0191 525 7344
Fax: +44 0191 525 7007
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (Please
note new email address)
-Original Message-
From: Robertson Lee - lerobe
Sent: 21 June 2001 15:33
To: ORACLE LIST (E-mail)
Subject: FW: sqlloader
- lerobe To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
lerobe@acxiom cc:
.co.uk Subject: FW: sqlloader problem
HiStarting with 8i you have the
"filler"option in SQL*Loader control file=which does what you want.
Thanks Jack. It was
indeed on 8i (I should have mentioned this) and the FILLER keyword worked like a
charm.
I love this list
!!
Lee
The information contained in this communication is
Title: RE: Sqlloader on VSAM file
Raymond,
Please
forgive me, but I am not sure now if you are asking a question or stating that
you're ok. Your control file looks ok except I 'define' my fields
differently. I am sending you an example below. I am assuming your
amount fields has 2 decimal
1 - 100 of 125 matches
Mail list logo