RE: Sqlloader question

2003-09-12 Thread David Scott
Roland, There are 2 techniques you can use. The first is what I call a 'dynamic control file' - other posters have given you examples of that one, using sed. The next is create a 'loop loader'; essentially a script file that fires off sqlldr for each loadable file. Here's an overly simple example

RE: Sqlloader question

2003-09-11 Thread Scott Canaan
The way I handled a similar situation was to create a default SQL*Loader file with something recognizable in the place that you want to do the substitution (in your case, the infile filename). Then, I wrote a shell script that created the correct filename and copied the default SQL*Loader file to

Re: Sqlloader 8.1.7.4 problem

2002-09-11 Thread Jack van Zanen
Hi maybe not very backwards compatible. All controlfile options still valid for 8.1.8? Jack "Rodrigues,

RE: SQLLOader + nls_date_language

2002-07-19 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

RE: SQLLoader

2002-07-19 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

Re: SQLLOADER - please help

2002-07-01 Thread Joe Testa
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 >Col

RE: SQLLOADER - please help

2002-07-01 Thread Long . Nguyen
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. Ask

Re: SQLLOADER - please help

2002-07-01 Thread Alexandre Gorbatchev
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 record

Re: SQLLOADER - please help <-- Attachment History Removed

2002-07-01 Thread Jack van Zanen
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 is giv

RE: sqlloader tuning

2002-06-26 Thread Nalla Ravi
Hi, Beth and Kirti thank you so much for your clarification. cheers, ravi --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > 1. Review this article by Stephen Andert: > http://oracle.oreilly.com/news/oraclesqlload_0401.html > 2. No. > > - Kirti > > - Original Message - > To: "M

RE: sqlloader tuning

2002-06-26 Thread Seefelt, Beth
Ravi, You can't use sql functions in the control file with direct=true. You can do a direct load, and then run a sql script on the loaded data to make changes. Sometimes the performance gains from the direct load make that worthwhile. Set bindsize=rows*rowlength where rows is the number of ro

RE: sqlloader tuning

2002-06-26 Thread Deshpande, Kirti
1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 9:08 AM > Hi all, > > Can any one please tell me what i

RE: Sqlloader

2002-06-06 Thread Scott . Shafer
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

2002-06-06 Thread Suzy Vordos
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 Farou

Re: Sqlloader

2002-06-06 Thread Stephane Faroult
[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

RE: Sqlloader

2002-06-06 Thread Scott . Shafer
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, > > Any

Re: Sqlloader

2002-01-22 Thread Rachel Carmichael
why not just rename the log file after the script runs? --- [EMAIL PROTECTED] wrote: > Hallo all you gurus, > > Anyone who can help me with this: > > I have this unix script: In the script I wamt to create a logfile > for every day that I run this script so that thel logfile will look > like:

RE: Sqlloader

2002-01-22 Thread Hallas John
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 < set verif off pages 0 echo off feed off term off lines 200 spool

RE: sqlloader question

2001-12-31 Thread Mercadante, Thomas F
Lyuda, Did you get an answer for this? You can try using the SUBSTR command to read the 7 char data string and rebuild it into something longer like: col_dat "substr(:col_seq,1,2) || '--' || substr(:col_seq,3,3) || '--' || substr(:col_seq,6,2)" Hope this helps Tom Mercadante Oracle Certified

Re: sqlloader question

2001-12-27 Thread Peter . McLarty
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 McLarty            

Re: SqlLoader

2001-12-13 Thread Nikunj Gupta
: Multiple recipients of list ORACLE-L Sent: Thursday, December 13, 2001 06:35 AM Subject: RE: 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

RE: SqlLoader

2001-12-13 Thread Stephen Andert
Laura, One idea, select username and status from dba_user. I would guess that should work, but ... Another thought, you say you can connect via sqlplus. Is your sqlplus connection of the form user/password@sid or just user/password? If it is the latter, your environment vairable ORACLE_HOME

RE: SqlLoader

2001-12-13 Thread Stephen Andert
Laura, One idea, select username and status from dba_user. I would guess that should work, but ... Another thought, you say you can connect via sqlplus. Is your sqlplus connection of the form user/password@sid or just user/password? If it is the latter, your environment vairable ORACLE_HOME

RE: SqlLoader

2001-12-13 Thread Orr, Steve
PROTECTED]]Sent: Thursday, December 13, 2001 7:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 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

RE: SqlLoader

2001-12-13 Thread Robertson Lee - lerobe
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

RE: SqlLoader

2001-12-13 Thread Robertson Lee - lerobe
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 'stupid' that I am or are not doing.  Yes, I did try setting the Oracle_sid parameter when

RE: SqlLoader

2001-12-13 Thread Ron Rogers
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 some

RE: SqlLoader

2001-12-13 Thread Burton, Laura L.
?   Thanks, Laura -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 4:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SqlLoader Stupid question I know but is the correct SID set ??   and watch out fo

RE: SqlLoader

2001-12-13 Thread Robertson Lee - lerobe
-LSubject: RE: 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 c

RE: SqlLoader

2001-12-12 Thread Burton, Laura L.
o the database.   Laura -Original Message-From: Jeff Cox [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 12, 2001 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SqlLoader Laura,   The username that you are trying to use, does this usernam

Re: SqlLoader

2001-12-12 Thread Jeff Cox
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 connect via sqlplus and/or svrmgr to a session, this does not mean that you will be able to load data int

RE: Sqlloader

2001-11-14 Thread Robertson Lee - lerobe
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 TERMINAT

Ang: RE: Sqlloader - important

2001-11-14 Thread Roland . Skoldblom
<[EMAIL PROTECTED] cc: ate.ny.us> Subject: RE: Sqlloader - important Sent by: [EMAIL PROTECTED] 11/13/2001 10:40 AM Please respond to ORACLE-L

RE: Sqlloader - important

2001-11-13 Thread DBarbour
MAIL PROTECTED] cc: ate.ny.us> Subject: RE: Sqlloader - important Sent by:

Re: Sqlloader

2001-11-13 Thread Igor Neyman
Roland, Your log file tells you exactly, what to do: use 'TRAILING NULLCOLS' in your ctl-file (when the last column value is NULL). BTW, why don't you ever RTFM??? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]

RE: Sqlloader - important

2001-11-13 Thread Mohan, Ross
:-) -Original Message- Sent: Tuesday, November 13, 2001 12:15 PM To: Multiple recipients of list ORACLE-L '98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 1

RE: RE: Sqlloader

2001-11-13 Thread Thomas, Kevin
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 'c

Re: Sqlloader - important

2001-11-13 Thread tday6
Count your number of single quotes ('). It should be an even number. Roland.Skoldb lom

Re: Sqlloader - important

2001-11-13 Thread DBarbour
You have mismatched quotes. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl

RE: RE: Sqlloader

2001-11-13 Thread Kevin Lange
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 fi

Re: Sqlloader - important

2001-11-13 Thread G . Plivna
'98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

RE: Sqlloader - important

2001-11-13 Thread Paul . Parker
Roland, You are missing a comma and a quote. It should be (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", not (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", See the difference? Paul -Original Message- Sent: Tuesday, November

Ang: RE: Sqlloader

2001-11-13 Thread Ron Rogers
Roland, It looks like Oracle can't understand '98'!', as a valid seperated field. Tyr inserting the missing comma after the 98. ROR mª¿ªm >>> [EMAIL PROTECTED] 11/13/01 10:20AM >>> Why does this sqlloader ctl file giveme this errormessage? the control file looks like: load data infile 'c:\k

RE: Sqlloader - important

2001-11-13 Thread Mercadante, Thomas F
You are missing a comma and another single quote: orig==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", new==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", Hope this helps! :) Tom Mercadante Oracle Certified Professional -Origin

RE: Sqlloader - important

2001-11-13 Thread Robertson Lee - lerobe
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 gi

RE: Sqlloader - important

2001-11-13 Thread Ivan_Rivera
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,'?','

RE: Sqlloader - important

2001-11-13 Thread Ball, Terry
(KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", ^^^ No comma seperating the '98' and the !' Should probably read: (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", -Original Message- Sent: Tue

Ang: RE: Sqlloader

2001-11-13 Thread Roland . Skoldblom
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-9

RE: Sqlloader

2001-11-13 Thread Mercadante, Thomas F
Hi Roland, Try using the DECODE statement rather than TRANSLATE: BUT_OMS "DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS)", The above says: Ifthe value of BUT_OMS='!', change it to '99', elsif the value of BUT_OMS='?', change it to 'No Info', else insert the value provided. Hop

RE: SQLLOADER question.

2001-09-23 Thread Nirmal Kumar Muthu Kumaran
egindata 123,20010920,20,30,35 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

RE: SQLLOADER question.

2001-09-21 Thread Mercadante, Thomas F
Ron, try this: Load data infile * Append Into table tab1 trailing nullcols ( col1 terminated by "," , col2 terminated by ",", col3 terminated by "," , col4 terminated by "," ":col3*.07", col5 terminated by "," ) begindata 123,20010920,20,30,35 123,20010920,20,30,35 123,20010920,20,30,35 I

RE: SQLLOADER question.

2001-09-21 Thread Ken Janusz
Get yourself a copy of Oracle SQL*Loader by Gennick & Mishra, O'Reilly Books. I reviewed the discussion of it in Ch 8 of the book. It looks like you need to script a Function and then reference the Function name in the Control File. Hope this helps. It's not to simple so you need to get the

Re: sqlloader-bad file

2001-09-04 Thread Rachel Carmichael
you don't put it in the control file. When you run sqlldr, just as you have control= you add log= 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: Tue, 04 Sep

RE: sqlloader-bad file

2001-09-04 Thread Hallas John
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

Re: sqlloader stops

2001-08-08 Thread Yosi Greenfield
So again I ask, how about running something while running your batched loads, so you can see - and even maybe let us know - what it's getting stuck on. You may even find that it's got NO sql session running, and the problem is in your batch process. That really sounds like your next step in debug

RE: sqlloader stops

2001-08-08 Thread lhoska
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 into the game

Re: sqlloader stops

2001-08-08 Thread Stephen Andert
Lyuda,   I'll jump into the game of 20 questions.   Is the batch file kicking off the jobs in serial (one after the other) or in parallel (maybe using & to put each one in the background)?         Stephen Andert>>> [EMAIL PROTECTED] 08/08/01 07:06AM >>>If I execute one load at the time maual

Re: sqlloader stops

2001-08-08 Thread lyudah
If I execute one load at the time maually it loads fine. It gives me hard time when I try to run multiple loads(one after another) through the batch file. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 9:05 PM > How abo

Re: sqlloader stops

2001-08-07 Thread Yosi Greenfield
How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: > Thanks Yosi. > No, that is not the case..:-( > > -Original Message- > Sent: Tuesday, August 07,

RE: sqlloader stops

2001-08-07 Thread lhoska
Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 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

Re: sqlloader stops

2001-08-07 Thread Yosi Greenfield
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 serv

RE: sqlloader stops

2001-08-07 Thread lhoska
My impression is the ERRORS parameter is set for each single load not number of loads. No, there is no bad file. Thanks David. -Original Message- Sent: Tuesday, August 07, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Just a stab here... Check the .bad files to see if you are

RE: sqlloader stops

2001-08-07 Thread David Wagoner
Just a stab here... Check the .bad files to see if you are getting any data rows kicked out due to errors. If so, you might be exceeding the ERRORS parameter by the time you finish the third file. HTH. David Wagoner DBA -Original Message- Sent: Tuesday, August 07, 2001 4:15 PM To: Mu

RE: sqlloader process dies

2001-08-01 Thread Stephen Andert
Lyuda,   What are your settings (BINDSIZE, ROWS, etc)?    Also how big and how many rollback segments do you have?  How big is their tablespace?       If you have any questions, please feel free to drop me a note.   Stephen Andert>>> [EMAIL PROTECTED] 07/31/01 04:30PM >>>I could do it but th

RE: sqlloader process dies

2001-07-31 Thread Kevin Lange
The items below are pure speculation : Do you see any error messages in anything like the alert log signifying a possible problem on the database ??? Tablespace full, temp space full, rollback segments ?? etc ?? Or . maybe an outside process like a backup coming thru and killing the datb

RE: sqlloader process dies

2001-07-31 Thread lhoska
I could do it but the trick it to load it all at once... -Original Message- Sent: Tuesday, July 31, 2001 7:06 PM To: Multiple recipients of list ORACLE-L Why don't you try to divide this load in several parts. Alex Hillman -Original Message- Sent: Tuesday, July 31, 2001 6:26 P

RE: sqlloader process dies

2001-07-31 Thread Hillman, Alex
Why don't you try to divide this load in several parts. Alex Hillman -Original Message- Sent: Tuesday, July 31, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -Original Message- Sent: Tuesday, July

RE: sqlloader process dies

2001-07-31 Thread lhoska
Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -Original Message- Sent: Tuesday, July 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Since it can't create a log file either ... how about space ??? running out of space on the machine ?? -Origina

RE: sqlloader process dies

2001-07-31 Thread Kevin Lange
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.

Re: sqlloader question

2001-07-03 Thread Jonathan Gennick
ROWS takes on a slightly different semantic meaning depending on whether your load is direct-path or conventional, but the practical effect is pretty much the same. For a conventional path load, ROWS specifies the number of rows for the bind array, which ends up being the number of rows loaded bet

RE: sqlloader question

2001-07-03 Thread Yosi
Lyuda, According to the good ol' doc, when you use a direct load with the ROWS param, Loader will count the rows it's building into blocks, and 'save' the blocks when each time ROWS is reached. I've used ROWS in direct loads, and it worked as advertised. The loads were still fast, and data was s

RE: Sqlloader on VSAM file

2001-06-11 Thread Burton, Laura L.
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 amou

RE: Sqlloader on VSAM file

2001-06-10 Thread Raymond Lee Meng Hong
Title: RE: Sqlloader on VSAM file [Raymond]  I did check on the source text file , I did't see a carriage return on this, according to the previous example , this is the 1 record A38001000307754A005516562HATIJAH BT BAKAR    199201300202 00

RE: Sqlloader on VSAM file

2001-06-08 Thread Burton, Laura L.
Title: RE: Sqlloader on VSAM file I do the same thing here at my shop and the record I download from a vsam file is 3574 in length.  When I view the download in the .txt format it is wrapped just like what your records look like below.  However, a new record does start on a new line, and it

RE: sqlloader reserved word is column name

2001-06-05 Thread Petrus, Mike (CAP, GEFA)
Excelent!! Thank you Kevin - it worked like a charm. Mike Petrus -Original Message- Sent: Tuesday, June 05, 2001 12:13 PM To: Multiple recipients of list ORACLE-L Directly from the "Oracle8i Utilities" manual "Because the following words have special meanings for SQL*Loader, Oracle C

Re: sqlloader reserved word is column name

2001-06-05 Thread Jonathan Gennick
Try placing the column name within quotes. For example: "PARTITION" POSITION (1) INTEGER EXTERNAL, ... Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, June 05, 2001, 1:10:58 PM, you wr

RE: sqlloader reserved word is column name

2001-06-05 Thread Kevin Lange
Yes.The manual states that you can use SQLLDR control words as column names if you enclose them in Double Quotes. If you do this you must remember to make the column names in UPPER CASE. So, to use a column name of PARTITION, say "PARTITION". -Original Message- Sent: Tuesday, June 0

RE: sqlloader reserved word is column name

2001-06-05 Thread Toepke, Kevin M
Directly from the "Oracle8i Utilities" manual "Because the following words have special meanings for SQL*Loader, Oracle Corporation recommends that you do not use them as names for tables or columns. If you do use them, the names should be enclosed in double quotation marks. " Kevin -Origina

Re: Sqlloader

2001-04-19 Thread Charlie Mengler
The use of "TRUNCATE" will delete all rows before starting the load process. -- sqlldr username/password log=ar.hist.log control=load_raw_pick.ctl OPTIONS (DIRECT=TRUE, ERRORS=9) UNRECOVERABLE LOAD DATA INFILE FaxCovers0416.csv BADFILE fax.bad DISCARDFILE fax.dsc DISCARDMAX 9 TRUNCATE IN

RE: Sqlloader

2001-04-19 Thread Vadim Gorbounov
Hell Roland, It is a table, you are about to load in, isnt it? If yes, there is better way - use "load data .. into table ... truncate". I dont think, Oracle has something to answer your original question. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, April 19, 2001 4

Re: Sqlloader

2001-04-19 Thread nlzanen1
Hi, Use "replace" as part of the controlfile and before any rows are loaded the table is emptied Jack Roland.Skoldbl

Re: Sqlloader

2001-04-19 Thread Ron Rogers
SQLLOADER allows you to APPEND, INSERT, REPLACE, or TRUNCATE at table that you are loading data into. Read the latest manual about the Control file and placing the options in the proper location. We use the "truncate" option on one of our large files that gets loaded with fresh data each day. W

Re: Sqlloader

2001-04-19 Thread Gregory Conron
On Thu, 19 Apr 2001, [EMAIL PROTECTED] wrote: > How can I within sqllldr call a pl/sql-procedure which deletes all rows from a table? You can't. You can, however, do one of two things: a) create a top level shell scripts which will first call a pl/sql procedure to delete the rows then call sqlldr

RE: Sqlloader

2001-04-06 Thread Bala, Prakash
Roland, Try this in your control file: column1 "replace(:column1, '?', '0')" , column2 "replace(:column2, '?', '0')" , This will work only with the conventional path. Prakash -Original Message- Sent: Friday, April 06, 2001 7:15 AM To: Multiple recipients of list ORACLE-L How can I

Re: sqlloader

2001-03-30 Thread Shankar Shanmugaswamy
Hi, If the OS in Unix, check the user .cshrc file you are logging in It should contain the Oracle HOME and other privileges for exec the /oracle/bin directory. S.S >>> [EMAIL PROTECTED] 03/30/01 08:31AM >>> Hallo, Can anyone tell me how to get sqlloader, how can I try and find out to see

RE: sqlloader

2001-03-30 Thread Cale, Rick T (Richard)
I think you can also check your oracle_home/bin directory and search for sqlldr*.exe Rick > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Friday, March 30, 2001 9:02 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: sqlloade

RE: sqlloader

2001-03-30 Thread Armstead, Michael A
If it is already installed, it should be in your $ORACLE_HOME/bin directory. The executable is named sqlldr. Michael Armstead Database Administrator, OCP-Certified Corporate & Finance Information Systems Glaxo SmithKline > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMA

Re: sqlloader

2001-03-30 Thread Stefan Jahnke
Hi, it comes already with Oracle. Just try sqlldr at the command line. You can actually find it in Oracle's bin directory. For a manual, see the Oracle Utilities Guide, it explains SQL Loader, Export and Import. [EMAIL PROTECTED] schrieb: > > Hallo, > > Can anyone tell me how to get sqlloade

RE: sqlloader

2001-03-30 Thread Mark Leith
Get to a command prompt and type sqlldr this will bring you in to the SQL*Loader command prompt, then type help. HTH Mark -Original Message- [EMAIL PROTECTED] Sent: Friday, March 30, 2001 02:31 To: Multiple recipients of list ORACLE-L Hallo, Can anyone tell me how to get sqlloader, h