RE: Sqlloader

[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,
> 
> Anyone whom can tellme how to rename the field names everytime a text file
> is inserted in a table. The new field names are specified in the sqlloader
> script.
> 
> Thanks in advance
> 
> 
> Roland
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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 FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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 Faroult
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[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
> 
> 
> 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: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Suzy Vordos
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLoader

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

Re: SqlLoader

[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 
into any table that you desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, 
  Laura L. 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 12, 2001 3:35 
  PM
  Subject: 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 

RE: SqlLoader

[Burton, Laura L.]

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.
 
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 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 into any table that you desire.
   
  HTH
   
  Regards,
   
  Jeff
  Tempe, AZ
  
- Original Message - 
From: 
Burton, 
Laura L. 
To: Multiple 
recipients of list ORACLE-L 
Sent: Wednesday, December 12, 2001 3:35 
PM
Subject: 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 

RE: SqlLoader

[Robertson Lee - lerobe]

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: 
  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 connected to 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 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 into any table that you desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, 
  Laura L. 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Wednesday, December 12, 2001 
  3:35 PM
  Subject: 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 

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

RE: SqlLoader

[Burton, Laura L.]

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

  -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 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: 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 connected to 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 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 into any table that you desire.
   
  HTH
   
  Regards,
   
  Jeff
  Tempe, AZ
  
- Original Message - 
From: 
Burton, Laura L. 
To: Multiple 
recipients of list ORACLE-L 
Sent: Wednesday, December 12, 2001 
3:35 PM
Subject: 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 The information contained in this communication 
  isconfidential, is intended only for the use of the recipientnamed 
  above, and may be legally privileged. If the reader of this message is not 
  the intended recipient, you arehereby notified that any dissemination, 
  distribution orcopying of this communication is strictly prohibited. 
  If you have received this communication in error, please re-send this 
  communication to the sender and delete the original message or any copy of 
  it from your computersystem.

RE: SqlLoader

[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 someone changed the password or parfile if you use that method?
can you run the sqlloader with a xx.PAR file and use the dba/passwd@connect and test 
the command string?
ROR mª¿ªm

>>> [EMAIL PROTECTED] 12/13/01 09:35AM >>>
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

-Original Message-
Sent: Thursday, December 13, 2001 4:05 AM
To: Multiple recipients of list ORACLE-L


Stupid question I know but is the correct SID set ??
 
and watch out for TWO_TASK !!
 
Regards
 
Lee

-Original Message-
Sent: Thursday, December 13, 2001 6:10 AM
To: Multiple recipients of list ORACLE-L


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.
 
Laura

-Original Message-
Sent: Wednesday, December 12, 2001 5:30 PM
To: Multiple recipients of list ORACLE-L


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 into any table that you
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

- Original Message - 
To: Multiple   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 on svrmgr and
through sqlplus with no problems.

Any ideas? 

Thanks, 
Laura 



The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. 
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SqlLoader

[Robertson Lee - lerobe]

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]]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 I started trying to figure out what was 
  wrong.
   
  Now 
  for my stupid question.  What is Two_Task?
   
  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 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: 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 
  connected to 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 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 into any table that you 
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, Laura L. 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Wednesday, December 12, 
  2001 3:35 PM
  Subject: 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 The information contained in this communication 
isconfidential, is intended only for the use of the recipientnamed 
above, and may be legally privileged. If the reader of this message is 
not the intended recipient, you arehereby notified that any 
dissemination, distribution orcopying of this communication is strictly 
prohibited. If you have received this communication in error, please 
re-send this communication to the sender and delete the original 
message or any copy of it from your 
computersystem.

RE: SqlLoader

[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 
  '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
  
-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 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: 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 
  connected to 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 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 into any table that you 
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, Laura L. 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Wednesday, December 12, 
  2001 3:35 PM
  Subject: 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 The information contained in this communication 
isconfidential, is intended only for the use of the recipientnamed 
above, and may be legally privileged. If the reader of this message is 
not the intended recipient, you arehereby notified that any 
dissemination, distribution orcopying of this communication is strictly 
prohibited. If you have received this communication in error, please 
re-send this communication to the sender and delete the original 
message or any copy of it from your 
computersystem.

RE: SqlLoader

[Orr, Steve]

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 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 when I started trying to figure out what was 
  wrong.
   
  Now 
  for my stupid question.  What is Two_Task?
   
  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 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: 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 
  connected to 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 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 into any table that you 
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, Laura L. 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Wednesday, December 12, 
  2001 3:35 PM
  Subject: 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 The information contained in this communication 
isconfidential, is intended only for the use of the recipientnamed 
above, and may be legally privileged. If the reader of this message is 
not the intended recipient, you arehereby notified that any 
dissemination, distribution orcopying of this communication is strictly 
prohibited. If you have received this communication in error, please 
re-send this communication to the sender and delete the original 
message or any copy of it from your 
computersystem.

RE: SqlLoader

[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 (echo $ORACLE_HOME
on Unix) decides what db to connect to and could be pointing you to a
different db.

HTH

Stephen Andert



>>> [EMAIL PROTECTED] 12/12/01 23:54 PM >>>
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.
 
Laura

-Original Message-
Sent: Wednesday, December 12, 2001 5:30 PM
To: Multiple recipients of list ORACLE-L


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 into any table that you
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

- Original Message - 
To: Multiple   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 on svrmgr and
through sqlplus with no problems.

Any ideas? 

Thanks, 
Laura 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SqlLoader

[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 (echo $ORACLE_HOME
on Unix) decides what db to connect to and could be pointing you to a
different db.

HTH

Stephen Andert



>>> [EMAIL PROTECTED] 12/12/01 23:54 PM >>>
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.
 
Laura

-Original Message-
Sent: Wednesday, December 12, 2001 5:30 PM
To: Multiple recipients of list ORACLE-L


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 into any table that you
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

- Original Message - 
To: Multiple   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 on svrmgr and
through sqlplus with no problems.

Any ideas? 

Thanks, 
Laura 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SqlLoader

[Nikunj Gupta]

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 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 I started trying to figure out what was 
  wrong.
   
  Now 
  for my stupid question.  What is Two_Task?
   
  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 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: 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 
  connected to 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 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 into any table that you 
desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, Laura L. 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Wednesday, December 12, 
  2001 3:35 PM
  Subject: 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 The information contained in this communication 
isconfidential, is intended only for the use of the recipientnamed 
above, and may be legally privileged. If the reader of this message is 
not the intended recipient, you arehereby notified that any 
dissemination, distribution orcopying of this communication is strictly 
prohibited. If you have received this communication in error, please 
re-send this communication to the sender and delete the original 
message or any copy of it from your 
computersystem.

RE: Sqlloader

[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 $SHELLSRCDIR/dbcontents.$TMS.log
select  'alter database rename file '''||name||''' to '''||name||''';'
from    v\$datafile;
column member format a50
select 'alter database rename file '''||member||''' to '''||member||''';'
from
v\$logfile;
spool off
whisky



Regards 
Peter Lomax (Oracle DBA) 
Expertise Oracle 
SG/DSI/SIMBAD/AT&P 
OrangeFrance 
Bureau: 
*: - [EMAIL PROTECTED] 
(:  (+33) (0)1 55 22 59 13 
fax: (+33) (0)1 55 22 39 69 
+++
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2002 08:45
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader



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:

2002-02-22laddabsg.log
and when i run the script tomorrow I want it to be:


2002-02-23laddabsg.log


anyone who can help me to complete this unix script



This line executes the sqlloader command and it is this logfile I want to have the runningdate in too.


sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl log=/d31/appl/konto/log/laddabsg.log




(See attached file: loadfast.sh)



Thanks in advance


Roland




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

Re: Sqlloader

[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:
> 
> 2002-02-22laddabsg.log
> and when i run the script tomorrow I want it to be:
> 
> 2002-02-23laddabsg.log
> 
> anyone who can help me to complete this unix script
> 
> 
> This line executes the sqlloader command and it is this logfile I
> want to have the runningdate in too.
> 
> sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl
> log=/d31/appl/konto/log/laddabsg.log
> 
> 
> 
> (See attached file: loadfast.sh)
> 
> 
> Thanks in advance
> 
> Roland
> 

> ATTACHMENT part 2 application/octet-stream name=loadfast.sh



__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[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.

Hope 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' and  the character ! with the value '99'.
I have this statement already.


BUT_OMS  "TRANSLATE(:BUT_OMS, '!','99')",

Thanks in advance


Roland S



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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]>
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(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID)",
ROLL_ID,
 PROFIL_ID "DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID)",
 AR,
 KVARTAL,
 MANAD,
 VECKA,
 DOKUMENTTEST_ARKFORMAT
"DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97'
,'99')",
 KAMPANJ_TYP,
 MX_URVAL,
 POSTBEFODRAN
"DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99')",
 PRINT_FORETAG_ID
"DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99')",
 STYCKKOSTNAD,
 FASTKOSTNAD_BREVMALL,
 FASTKOSTNAD_ARENDE,
 TOTAL_KOSTNAD,
 ANTAL_ÄRENDEN,
 ANTAL_BREVMALLAR_I_ARENDE,
 ANTAL_KUNDSEGMENT_I__ARENDE,
 ANTAL_KUNDER_I_URVAL,
 DATUM_HOS_KUND,
 AKTIVITETS_LOPNR,
 PRODUKTIONSENHET,
 AKTIVITETSDATUM,
BEHANDLINGSGRP)



but gets this error message, check the file:What does it mean and how should
I fix this:

(See attached file: arg.log)


Thanks in advance

Roland S



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[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 TERMINATED BY ';'
(BUTIKS_ID,
 BUT_NAMN,
 REGION_ID "DECODE(:REGION_ID,'!','98','?','97',:REGION_ID)",
 DISTRIKT_ID "DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID)",
ROLL_ID,
 PROFIL_ID "DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID)",
 AR,
 KVARTAL,
 MANAD,
 VECKA,
 DOKUMENTTEST_ARKFORMAT
"DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97'
,'99')",
 KAMPANJ_TYP,
 MX_URVAL,
 POSTBEFODRAN
"DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99')",
 PRINT_FORETAG_ID
"DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99')",
 STYCKKOSTNAD,
 FASTKOSTNAD_BREVMALL,
 FASTKOSTNAD_ARENDE,
 TOTAL_KOSTNAD,
 ANTAL_ÄRENDEN,
 ANTAL_BREVMALLAR_I_ARENDE,
 ANTAL_KUNDSEGMENT_I__ARENDE,
 ANTAL_KUNDER_I_URVAL,
 DATUM_HOS_KUND,
 AKTIVITETS_LOPNR,
 PRODUKTIONSENHET,
 AKTIVITETSDATUM,
BEHANDLINGSGRP)



but gets this error message, check the file:What does it mean and how should
I fix this:

(See attached file: arg.log)


Thanks in advance

Roland S



The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader

[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, how can I  try and find out  to see
if I  have it already installed ?
How do i Install it?

Roland Sköldblom






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader

[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 sqlloader, how can I  try and find out  to see if I  
>have it already installed ?
> How do i Install it?
> 
> Roland Sköldblom
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> This Mail has been checked for Viruses
> Attention: Encrypted Mails can NOT be checked !
> 
> * * *
> 
> Diese Mail wurde auf Viren ueberprueft
> Hinweis: Verschluesselte Mails koennen NICHT geprueft werden !
> --

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
AMS-Gebäude: E6 R08
Tel.: 0211/533-4893

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader

[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:[EMAIL PROTECTED]]
> Sent: Friday, March 30, 2001 8:31 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  sqlloader
> 
> Hallo,
> 
> Can anyone tell me how to get sqlloader, how can I  try and find out  to
> see if I  have it already installed ?
> How do i Install it?
> 
> Roland Sköldblom
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Armstead, Michael A
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader

[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: sqlloader
> 
> 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, how can I  try and find out  to
> see
> if I  have it already installed ?
> How do i Install it?
> 
> Roland Sköldblom
> 
> 
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader

[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 if I  
have it already installed ?
How do i Install it?

Roland Sköldblom






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shankar Shanmugaswamy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[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 in a sqlloader, the control file replace a ? with a 0 at the same
as it i sloading the data into the database?
The ? could be anywhere in any field.


Roland Sköldblom




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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.
or
b) if you are only deleting all the rows in the table, use either the replace
(which deletes everything in the target table) or truncate (which truncates the
target table) options in your sqlloader control file.

Cheers,
GC
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gregory Conron
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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. Works great.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/19/01 04:26AM >>>
How can I within sqllldr call a pl/sql-procedure which deletes all rows from a table?

Roland S

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[nlzanen1]

Hi,


Use "replace" as part of the controlfile and before any rows are loaded the
table is emptied

Jack


   
  
Roland.Skoldbl 
  
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> 
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: Sqlloader
  
om 
  
   
  
   
  
19-04-2001 
  
10:26  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



How can I within sqllldr call a pl/sql-procedure which deletes all rows
from a table?

Roland S

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying,  distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst &
Young is neither liable  for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[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:26 AM
To: Multiple recipients of list ORACLE-L


How can I within sqllldr call a pl/sql-procedure which deletes all rows from
a table?

Roland S

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader

[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 INTO TABLE fax_archive
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY X'27'
(
AccountNumber,
Comments,
CreatedBy,
CreatedByID,
CreatedOn,
FirstName,
LastModBy,
LastModByID,
LastModOn,
LastName,
Sheets,
Subject
)

Gregory Conron wrote:
> 
> 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.
> or
> b) if you are only deleting all the rows in the table, use either the replace
> (which deletes everything in the target table) or truncate (which truncates the
> target table) options in your sqlloader control file.
> 
> Cheers,
> GC
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gregory Conron
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader question

[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 the one that was going to be run, substituting the
created name for the default name.  In my case, I used it to determine
which partition should be loaded, but the concept should still work.  I
used sed to do that: 

sed "6s/partition()/partition(`echo $IN_DATE_FMT`)/g"
em_contact_hist_ld.orig
 > em_contact_hist_ld.ctl

In the script, this was followed by a call to sqlldr with the control
file em_contact_hist_ld.ctl.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: 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 with different extensions fo rinstance
the first time a file is going to be inserted will be konkurrenter.txt.1
and the next time the file will have the name konkurrenter.txt.2 etc.

How should I handle this?

Thanksin advance

Roland



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader question

[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:
export FILESPEC=/d31/datafiler/sema/incoming/konkurrenter.*
for FILENAME in $( ls ${FILESPEC} )
do
  sqlldr ${USER-PW} control=${CTL} data=${FILENAME}
log=${LOGPATH}/${FILENAME}.log
done

Both techniques are explained in my IOUG paper "SQL*Loader CAN Do That!". A
Windows example is also given. 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 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 to be inserted will be konkurrenter.txt.1
> and the next time the file will have the name konkurrenter.txt.2 etc.

> How should I handle this?

> Thanksin advance

> Roland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Scott
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader tuning

[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 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
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader tuning

[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 rows you want to
load before each commit, rowlength is the length of the records in the
flat file.

To see if you selected appropriate values, run a load of 1 record and
generate a log file -

sqlldr rows=2 bindsize=500 load=1 log=load.log

Check the log to see if you sized appropriately

Space allocated for bind array:4999560 bytes(10245 rows)
Read   buffer bytes: 500

Adjust accordingly - bindsize = 2*(4999560/10245) = 976

sqlldr rows=2 bindsize=976 load=1 log=load.log

Space allocated for bind array:976 bytes(2 rows)
Read   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 to use direct=true while using
function in control file?

DB:8.1.7 os:SUN SS
thanks for your help.

Cheers,
Ravi

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader tuning

[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: "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 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
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLOader + nls_date_language

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

RE: sqlloader stops

[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: 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
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know... 

Lyuda Hoska
(703)797-8656

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Wagoner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader stops

[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 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: 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
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know... 

Lyuda Hoska
(703)797-8656

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Wagoner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader stops

[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 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 text
> file.  It loaded 3 files again and stopped on the forth one.
> There is nothing in alert log (no errors).  Also, there is enough space on
> the drive where the logs are going.
> Oracle 7.3.4 on NT.
> If anyone has any idea please let me know...
>
> Lyuda Hoska
> (703)797-8656

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader stops

[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 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 wrong with a third text
> file.  It loaded 3 files again and stopped on the forth one.
> There is nothing in alert log (no errors).  Also, there is enough space on
> the drive where the logs are going.
> Oracle 7.3.4 on NT.
> If anyone has any idea please let me know...
>
> Lyuda Hoska
> (703)797-8656

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader stops

[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, 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.  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 text
> > file.  It loaded 3 files again and stopped on the forth one.
> > There is nothing in alert log (no errors).  Also, there is enough space on
> > the drive where the logs are going.
> > Oracle 7.3.4 on NT.
> > If anyone has any idea please let me know...
> >
> > Lyuda Hoska
> > (703)797-8656
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader stops

[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 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, 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.
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
text
> > > file.  It loaded 3 files again and stopped on the forth one.
> > > There is nothing in alert log (no errors).  Also, there is enough
space on
> > > the drive where the logs are going.
> > > Oracle 7.3.4 on NT.
> > > If anyone has any idea please let me know...
> > >
> > > Lyuda Hoska
> > > (703)797-8656
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Yosi Greenfield
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Thanks,
>
> Yosi
>
>
> -
> Yosi Greenfield
> Oracle Certified DBA
> [EMAIL PROTECTED]
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lyudah
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader stops

[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 maually it loads fine.  
It gives me hardtime when I try to run multiple loads(one after another) 
through the batchfile.- Original Message -To: "Multiple 
recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, 
August 07, 2001 9:05 PM> 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, 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.It> > > works fine on other servers.  
There is this 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 enoughspace 
on> > > the drive where the logs are going.> > > 
Oracle 7.3.4 on NT.> > > If anyone has any idea please let me 
know...> > >> > > Lyuda Hoska> > > 
(703)797-8656> >> > --> > Please see the official 
ORACLE-L FAQ: http://www.orafaq.com> 
> --> > Author: Yosi Greenfield> >   INET: 
[EMAIL PROTECTED]> >> > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051> 
> San Diego, California    -- Public 
Internet access / Mailing Lists> > 
> 
> To REMOVE yourself from this mailing list, send an E-Mail message> 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> 
> the message BODY, include a line containing: UNSUB ORACLE-L> > 
(or the name of mailing list you want to be removed from).  You may> 
> also send the HELP command for other information (like 
subscribing).> > --> > Please see the official ORACLE-L FAQ: 
http://www.orafaq.com> > 
--> > Author:> >   INET: 
[EMAIL PROTECTED]> >> > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051> 
> San Diego, California    -- Public 
Internet access / Mailing Lists> > 
> 
> To REMOVE yourself from this mailing list, send an E-Mail message> 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> 
> the message BODY, include a line containing: UNSUB ORACLE-L> > 
(or the name of mailing list you want to be removed from).  You may> 
> also send the HELP command for other information (like 
subscribing).>> --> Thanks,>> 
Yosi>>> 
-> Yosi 
Greenfield> Oracle Certified DBA> 
[EMAIL PROTECTED]>>> --> Please see the 
official ORACLE-L FAQ: http://www.orafaq.com> --> 
Author: Yosi Greenfield>   INET: 
[EMAIL PROTECTED]>> Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051> San Diego, 
California    -- Public Internet access / 
Mailing Lists> 
> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the 
message BODY, include a line containing: UNSUB ORACLE-L> (or the name of 
mailing list you want to be removed from).  You may> also send the 
HELP command for other information (like subscribing).-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
lyudah  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: sqlloader stops

[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 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 maually it loads 
  fine.  It gives me hardtime when I try to run multiple loads(one 
  after another) through the batchfile.- Original Message 
  -To: "Multiple recipients of list ORACLE-L" 
  <[EMAIL PROTECTED]>Sent: Tuesday, August 07, 2001 9:05 
  PM> 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, 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.It> > > works fine on other servers.  
  There is this 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 enoughspace 
  on> > > the drive where the logs are going.> > > 
  Oracle 7.3.4 on NT.> > > If anyone has any idea please let me 
  know...> > >> > > Lyuda Hoska> > > 
  (703)797-8656> >> > --> > Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com> > --> 
  > Author: Yosi Greenfield> >   INET: 
  [EMAIL PROTECTED]> >> > Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051> 
  > San Diego, California    -- Public 
  Internet access / Mailing Lists> > 
  > 
  > To REMOVE yourself from this mailing list, send an E-Mail message> 
  > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
  in> > the message BODY, include a line containing: UNSUB 
  ORACLE-L> > (or the name of mailing list you want to be removed 
  from).  You may> > also send the HELP command for other 
  information (like subscribing).> > --> > Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com> > --> 
  > Author:> >   INET: [EMAIL PROTECTED]> 
  >> > Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051> > San Diego, 
  California    -- Public Internet access 
  / Mailing Lists> > 
  > 
  > To REMOVE yourself from this mailing list, send an E-Mail message> 
  > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
  in> > the message BODY, include a line containing: UNSUB 
  ORACLE-L> > (or the name of mailing list you want to be removed 
  from).  You may> > also send the HELP command for other 
  information (like subscribing).>> --> 
  Thanks,>> Yosi>>> 
  -> Yosi 
  Greenfield> Oracle Certified DBA> 
  [EMAIL PROTECTED]>>> --> Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com> --> 
  Author: Yosi Greenfield>   INET: 
  [EMAIL PROTECTED]>> Fat City Network Services    
  -- (858) 538-5051  FAX: (858) 538-5051> San Diego, 
  California    -- Public Internet access 
  / Mailing Lists> 
  > 
  To REMOVE yourself from this mailing list, send an E-Mail message> to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the 
  message BODY, include a line containing: UNSUB ORACLE-L> (or the name 
  of mailing list you want to be removed from).  You may> also send 
  the HELP command for other information (like subscribing).-- 
  Please see the official ORACLE-L FAQ: 

Re: sqlloader stops

[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 debugging. Check it out, it
might help.

y

lyudah wrote:

> 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 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, 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.
> 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
> text
> > > > file.  It loaded 3 files again and stopped on the forth one.
> > > > There is nothing in alert log (no errors).  Also, there is enough
> space on
> > > > the drive where the logs are going.
> > > > Oracle 7.3.4 on NT.
> > > > If anyone has any idea please let me know...
> > > >
> > > > Lyuda Hoska
> > > > (703)797-8656
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Yosi Greenfield
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Thanks,
> >
> > Yosi
> >
> >
> > -
> > Yosi Greenfield
> > Oracle Certified DBA
> > [EMAIL PROTECTED]
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Yosi Greenfield
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lyudah
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Re: sqlloader question

[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               E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

    - Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=









[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
28/12/2001 04:55 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        sqlloader question


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
for that column comes in straight text  ( no dashes, of course ).  It is 7
positions long.
Is there a way to somehow input dashes using control file while loading
data?  I've looked 'concatenate' sqlloader command.  It is not going to take
care of my need.
Thank you to everyone who replies.  Have a safe a joyful new year.

Lyuda Hoska

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
This transmission is for the intended addressee only and is confidential information.  If you have received this transmission in error, please delete it and notify the sender.  The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

RE: sqlloader question

[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 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 ##--###--## (note dashes in between).  Dashes are
being stored in the database! (don't ask me why :-)  ).  My input file data
for that column comes in straight text  ( no dashes, of course ).  It is 7
positions long.
Is there a way to somehow input dashes using control file while loading
data?  I've looked 'concatenate' sqlloader command.  It is not going to take
care of my need.
Thank you to everyone who replies.  Have a safe a joyful new year.

Lyuda Hoska

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader question

[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 saved at the number of ROWS specified.

There is a difference between a 'save' during a 
direct load with ROWS, and a COMMIT during a
conventional load with ROWS. According to the doc,
the only difference is that during a direct load,
any indexes are marked unusable. If the load
crashes, 'saved' rows will still be there, and
you're indexes will need to be recreated.

(You're indexes would need to be recreated anyway
if a direct load crashes. Just that if you use ROWS,
whatever's been saved so far is saved.)

Hope this helps somewhat,

Yosi




> -Original Message-
> From: [EMAIL 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 and K.Loney ROWS is the number of rows to buffer 
> together for an
> insert and commit.  Default value is 64.
> According to one of my coworkers specifying ROWS in combination with
> LOAD=DIRECT is not a good idea.  Supposedly it will confuse 
> and slow down
> the load, possibly throw it to a non-direct load.  The theory 
> is based on
> the following idea:  during direct load sql loader is not 
> supposed to count
> and commit records.
> Does it sound like true?
> 
> Lyuda Hoska
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader question

[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 between commits. For a direct-path
load, ROWS specifies the number of rows to read from the
input file before saving them to the database. The semantics
of commit don't apply to direct-path load: for example, triggers don't
fire. Specifying ROWS in conjunction with DIRECT will NOT
cause your load to use the conventional path. Saving at the
end of a direct-path load (the default) is best
performance-wise, but the tradeoff is that if the load
fails, you get to do it ALL over again. Specifying a value
for ROWS puts a limit on the amount of the load that you
will need to redo in the event 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> There is an option called ROWS.  According to Oracle Complete reference by
lcc> G.Koch and K.Loney ROWS is the number of rows to buffer together for an
lcc> insert and commit.  Default value is 64.
lcc> According to one of my coworkers specifying ROWS in combination with
lcc> LOAD=DIRECT is not a good idea.  Supposedly it will confuse and slow down
lcc> the load, possibly throw it to a non-direct load.  The theory is based on
lcc> the following idea:  during direct load sql loader is not supposed to count
lcc> and commit records.
lcc> Does it sound like true?

lcc> Lyuda Hoska

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLOADER question.

[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 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 4 be the value of (col3 * .07). I have RTFM and other
books but it seems that you are not allowed to perform calculations during
the load except the date functions.
Am I correct in my understanding?

Control file info:

Load data
Append
Into table tab1
trailing nullcols
( col1 terminated by "," ,
 col2 terminated by "," "TO_DATE(:col2,'MMDD')",  
 col3 terminated by "," ,
 col4 terminated by "," ,
 col5 terminated by "," )

The source data has values in each location:
123,20010920,20,30,35

Any Ideas?
Thanks,
Ron
ROR mª¿ªm 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLOADER question.

[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 just ran 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 be the value of (col3 * .07). I have RTFM and other
books but it seems that you are not allowed to perform calculations during
the load except the date functions.
Am I correct in my understanding?

Control file info:

Load data
Append
Into table tab1
trailing nullcols
( col1 terminated by "," ,
 col2 terminated by "," "TO_DATE(:col2,'MMDD')",  
 col3 terminated by "," ,
 col4 terminated by "," ,
 col5 terminated by "," )

The source data has values in each location:
123,20010920,20,30,35

Any Ideas?
Thanks,
Ron
ROR mª¿ªm 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLOADER question.

[Nirmal Kumar Muthu Kumaran]

Hi,

You can use the same with little modification. Since if there is more no. of
columns, then "terminated by" is more headache.

Load data
infile *
Append
Into table tab1
fields terminated by ','
trailing nullcols
( col1 ,  col2 , col3 , col4 ":col3*.07", col5)
begindata
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: SQLLOADER question.
> 
> 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 just ran 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 be the value of (col3 * .07). I have RTFM and other
> books but it seems that you are not allowed to perform calculations during
> the load except the date functions.
> Am I correct in my understanding?
> 
> Control file info:
> 
> Load data
> Append
> Into table tab1
> trailing nullcols
> ( col1 terminated by "," ,
>  col2 terminated by "," "TO_DATE(:col2,'MMDD')",  
>  col3 terminated by "," ,
>  col4 terminated by "," ,
>  col5 terminated by "," )
> 
> The source data has values in each location:
> 123,20010920,20,30,35
> 
> Any Ideas?
> Thanks,
> Ron
> ROR mª¿ªm 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Ang: RE: Sqlloader

[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-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S





"Mercadante, Thomas F" <[EMAIL PROTECTED]>@fatcity.com den 2001-11-13 05:10 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:

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.

Hope 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' and  the character ! with the value '99'.
I have this statement already.


BUT_OMS  "TRANSLATE(:BUT_OMS, '!','99')",

Thanks in advance


Roland S



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).









--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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: 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(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ball, Terry
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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,'?','98','!','97', :KAMPANJTYP_ID)" ?


Later, Ivan


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader - important



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,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)



SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated



Thanks in advance


Roland S



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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 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,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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


-Original 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 BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Ang: RE: Sqlloader

[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:\kam\kampanj.txt'
TRUNCATE
into table  kampanjtyp_kopia
FIELDS TERMINATED BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S





"Mercadante, Thomas F" <[EMAIL PROTECTED]>@fatcity.com den 2001-11-13 05:10 PST

Sänd svar till [EMAIL PROTECTED] 

Sänt av:  [EMAIL PROTECTED] 


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:

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.

Hope 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' and  the character ! with the value '99'.
I have this statement already.


BUT_OMS  "TRANSLATE(:BUT_OMS, '!','99')",

Thanks in advance


Roland S



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).









--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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 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 BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader - important

[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/



   

Roland.Skoldbl 

[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   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:

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-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Sqlloader

[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 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-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S





"Mercadante, Thomas F" <[EMAIL PROTECTED]>@fatcity.com den 2001-11-13
05:10 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:

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.

Hope 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' and  the character ! with the value '99'.
I have this statement already.


BUT_OMS  "TRANSLATE(:BUT_OMS, '!','99')",

Thanks in advance


Roland S



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader - important

[DBarbour]

You have mismatched quotes.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

Roland.Skoldbl 

[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Sqlloader - important

om 

   

   

11/13/2001 

09:45 AM   

Please respond 

to 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,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader - important

[tday6]

Count your number of single quotes (').  It should be an even number.


   

Roland.Skoldb  

lom  To: Multiple recipients of list ORACLE-L  

@ica.se  <[EMAIL PROTECTED]>

Sent by: rootcc:   

 Subject: Sqlloader - important

   

11/13/2001 

10:45 AM   

Please 

respond to 

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,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Sqlloader

[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:\kam\kampanj.txt'
TRUNCATE
into table  kampanjtyp_kopia
FIELDS TERMINATED BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S





"Mercadante, Thomas F" <[EMAIL PROTECTED]>@fatcity.com den 2001-11-13
05:10 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:

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.

Hope 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' and  the character ! with the value '99'.
I have this statement already.


BUT_OMS  "TRANSLATE(:BUT_OMS, '!','99')",

Thanks in advance


Roland S



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[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 13, LV1050 Rîga
http://www.itsystems.lv/gints/



 

Roland.Skoldbl

[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
Sent by: cc:

[EMAIL PROTECTED]   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:

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-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader - important

[DBarbour]

I think it's really amazing how many people spotted the error.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
  
"Mercadante,   
  
Thomas F"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
<[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
  
   
  
   
  




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


-Original 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 BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sqlloader 8.1.7.4 problem

[Jack van Zanen]

Hi

maybe not very backwards compatible. All controlfile options still valid
for 8.1.8?


Jack


   

  "Rodrigues,  

  Bryan"   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  Subject:  Sqlloader 8.1.7.4 problem 

  Sent by: 

  [EMAIL PROTECTED] 

   

   

  11-09-2002 17:24 

  Please respond to

  ORACLE-L 

   

   




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: unrecognized processing option

But when I run the same file using the same control file with sqlloader
7.3.4 connecting to the same database it runs fine.
I have opened a tar with Oracle but results have been disappointing. It is
probably something simple, but could someone please help me?
Thanks,
Bryan Rodrigues
DBA
Elcom, Inc.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodrigues, Bryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this

Re: SQLLOADER - please help

[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
defined. Loader's suggestion "use TRAILING NULLCOLS" is errorprone and
stupid even when the problem is with row structure.

hth
Alexandre
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 10:28 AM


> 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 table RIK2.IMP_NIELSEN
>
> What  does that mean and how can I change this ctl file,
>
>
>
> (See attached file: nielsen.ctl)
>
> Thanks in advance
>
> Roland
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQLLOADER - please help

[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 the table owner or DBA to change the maxextents value for the table to a large 
value.

Long

-Original Message-
Sent: Monday, 1 July 2002 6:28 PM
To: Multiple recipients of list ORACLE-L


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 table RIK2.IMP_NIELSEN

What  does that mean and how can I change this ctl file,



(See attached file: nielsen.ctl)

Thanks in advance

Roland


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQLLOADER - please help

[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
>Column not found before end of logical record (use TRAILING NULLCOLS)
>ORA-01631: max # extents (20) reached in table RIK2.IMP_NIELSEN
>
>What  does that mean and how can I change this ctl file,
>
>
>
>(See attached file: nielsen.ctl)
>
>Thanks in advance
>
>Roland
>
>
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader-bad file

[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] [mailto:[EMAIL PROTECTED]]
Sent: 04 September 01 10:45
To: Multiple recipients of list ORACLE-L
Subject: sqlloader-bad file



Hallo all you gurus,


How should l I write in the controlfile(.ctl-file) if i want to get a logfile, with all the explanation of the errors.?



Roland


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

Re: sqlloader-bad file

[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 2001 01:45:25 -0800
>
>Hallo all you gurus,
>
>How should l I write in the controlfile(.ctl-file) if i want to get a 
>logfile, with all the explanation of the errors.?
>
>
>Roland
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader process dies

[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.  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.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader process dies

[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 ??

-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 log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader process dies

[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 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 ??

-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 log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader process dies

[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 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 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 ??

-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 log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader process dies

[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
datbase ??

Or  maybe a cleanup process coming thru on the OS thinking that the job
is a runaway because its been running so long and kills it ??

Why don't you spool the output of the job to a file someplace and try to
find out where the failure is occuring ??

-Original Message-
Sent: Tuesday, July 31, 2001 6:31 PM
To: Multiple recipients of list ORACLE-L


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 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 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 ??

-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 log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message B

RE: sqlloader process dies

[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 the trick it to load it all at 
once...-Original Message-Sent: Tuesday, July 31, 2001 7:06 
PMTo: Multiple recipients of list ORACLE-LWhy don't you try to 
divide this load in several parts.Alex Hillman-Original 
Message-Sent: Tuesday, July 31, 2001 6:26 PMTo: Multiple recipients 
of list ORACLE-LThank you Kevin.No, drive has plenty of 
space.Any one else has a guess?-Original Message-Sent: 
Tuesday, July 31, 2001 5:07 PMTo: Multiple recipients of list 
ORACLE-LSince it can't create a log file either ... how about space 
???  running outof space on the machine ??-Original 
Message-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 but the filesize remains 0 bytes.  It 
remains 0 size until the next day when new processkicks off.  The 
described scenario occurs day after day.  It is a cron jobkicked from a 
batch file running multiple loads simultaneously.  There aretwo 
particular loads that die every day...Anyone has any idea?Thank you for 
your help  Lyuda-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Kevin Lange  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Hillman, Alex  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Ang: RE: Sqlloader - important

[Roland . Skoldblom]

Yes and i should have checked the  error more myself but was tired

Roland





[EMAIL PROTECTED]@fatcity.com den 2001-11-13 15:05 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:


I think it's really amazing how many people spotted the error.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002



"Mercadante,
Thomas F"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
<[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






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


-Original 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 BY ';'
 (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
KAMPANJTYP_NAMN)


SQL*Loader-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated


Thanks in advance

Roland S


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).









--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader on VSAM file

[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 looks like yours does the same thing.  In your .ctl member just treat the record as if were not wrapped.  It will work.

Laura


-Original Message-
From: Raymond Lee Meng Hong [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 4:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader on VSAM file



  Hello , currently I have a set of data download from IBM VSAM file format
such as these


A38001000307754A005516562HATIJAH BT
BAKAR    199201300202
850
A38001053088697A006106290ALIBABAKA
R    1992013001018
50
A38001053406059A005637195SALBIAH B
RAHMAT  199201300101000
0850
A38001157190166A005249952RAIDAH AB
U TALIB    199201300100850
0850


Actually of the the field is fixed on the length , but for the name which it
auto-carriage return down to next line , how can I configure my sqlloader to
capable for this format , as well as I know ,sqlloader can only download
ASCII (1 line per line on fetching record , but how about this when the line
is fix on 60 per line and the remaining record will continous in next line ?
how to capable for this ??


Raymond fall asleep in waiting for the Q.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raymond Lee Meng Hong
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader on VSAM file

[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 850 
  
  this is the 2nd record and so on .and for the first 6 character is the 
  agent code , which will not be the same like A38001, might be something else 
  F41010..or whatever ..
  A38001053088697A006106290ALIBABAKA R    
  1992013001018 50 
  
  here 
  is my control files. . if the record is like this 1 
  line/record.
  A38001053088697A006106290ALIBABAKAR 
  199201300101850 
  
  LOAD DATAINFILE AAA.DATAPPEND INTOTABLE 
  LN21PNB(FINANCE_CD    
  position(1:6)DECIMAL 
  EXTERNAL, MEMBERSHIP_NO    
  position(7:15)CHAR, ICNO    
  position(16:29)CHAR, NAME    
  position(30:69)CHAR, CERTNO   
  position(70:75) CHAR, TXN_DATE 
  position(76:83)DATE 
  'MMDD', LOAN_AMT    
  position(84:89)DECIMAL EXTERNAL, REPAY_AMT 
  position(90:96) DECIMAL EXTERNAL, REASON_CD 
  position(97:98) DECIMAL EXTERNAL, REPAY_MAG 
  position(99:102) DECIMAL EXTERNAL)
  sorry 
  for any misleading.
   
   
   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 looks like yours does the same thing.  In your .ctl 
  member just treat the record as if were not wrapped.  It will 
  work.
  Laura 
  -Original Message- From: 
  Raymond Lee Meng Hong [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, June 08, 2001 4:06 AM To: Multiple recipients of list ORACLE-L Subject: Sqlloader on VSAM file 
    Hello , currently I have a set of data download from 
  IBM VSAM file format such as these 
  A38001000307754A005516562HATIJAH BT BAKAR    
  199201300202 850 A38001053406059A005637195SALBIAH B RAHMAT  
  199201300101000 0850 A38001157190166A005249952RAIDAH AB U 
  TALIB    
  199201300100850 0850 
  Actually of the the field is fixed on the length , but for the 
  name which it auto-carriage return down to next line , 
  how can I configure my sqlloader to capable for this 
  format , as well as I know ,sqlloader can only download ASCII (1 line per line on fetching record , but how about this when the 
  line is fix on 60 per line and the remaining record 
  will continous in next line ? how to capable for this 
  ?? 
  Raymond fall asleep in waiting for the Q. 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: Raymond Lee Meng Hong   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: Sqlloader on VSAM file

[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 
amount fields has 2 decimal positions.  Let me know if you need anything 
else.
Laura
___
options (errors=99)load datainfile 
'pmiwkly.dat'truncate
 
into table pmiwklytrailing 
nullcols(badge position(01- 
06) 
char,wedte position(07- 
12) 
date    "MMDDYY"     
"decode(:WEDTE, '00', null, 
:WEDte)",mgmtded    
position( 17- 17)    
CHAR,unionded    
POSITION( 18- 18) 
CHAR,esophrs  
POSITION( 78- 82) INTEGER 
EXTERNal    
":ESOPHRS/10",esopamt 
POSITION( 83- 89) INTEGER 
EXTERNAL    
":ESOPAMT/100",mesophrs    
POSITION( 90- 94) INTEGER 
EXTERNAL    
":MESOPHRS/10",mesopamt   
POSITION( 95-101) INTEGER 
EXTERNAL    
":MESOPAMT/100"
)
_

-Original Message-From: Raymond Lee Meng Hong 
[mailto:[EMAIL PROTECTED]]Sent: Sunday, June 10, 2001 9:25 
PMTo: Multiple recipients of list ORACLE-LSubject: 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 850 
this is the 2nd record and so on 
.and for the first 6 character is the agent code , which will not be the 
same like A38001, might be something else F41010..or whatever 
..
A38001053088697A006106290ALIBABAKA R    
1992013001018 50 

here is my control files. . if the record is 
like this 1 line/record.
A38001053088697A006106290ALIBABAKAR 
199201300101850 

LOAD DATAINFILE 
AAA.DATAPPEND INTOTABLE 
LN21PNB(FINANCE_CD    
position(1:6)DECIMAL 
EXTERNAL, MEMBERSHIP_NO    
position(7:15)CHAR, ICNO    
position(16:29)CHAR, NAME    
position(30:69)CHAR, CERTNO   
position(70:75) CHAR, TXN_DATE 
position(76:83)DATE 
'MMDD', LOAN_AMT    
position(84:89)DECIMAL 
EXTERNAL, REPAY_AMT position(90:96) 
DECIMAL EXTERNAL, REASON_CD 
position(97:98) DECIMAL 
EXTERNAL, REPAY_MAG position(99:102) 
DECIMAL EXTERNAL)
sorry for any misleading
  

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

[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 given in
the error message (trailing nullcols)


Jack


   

  Roland.Skoldblom@

  ica.se   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  Sent by: cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  [EMAIL PROTECTED] Subject:  SQLLOADER - please help   

   

   

  01-07-2002 10:28 

  Please respond to

  ORACLE-L 

   

   





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 table RIK2.IMP_NIELSEN

What  does that mean and how can I change this ctl file,



(See attached file: nielsen.ctl)

Thanks in advance

Roland






===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
===






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE

RE: sqlloader reserved word is column name

[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
-Original Message-
Sent: Tuesday, June 05, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L


Can anyone help?

I am attempting to load a table, using SQL*Loader, where the table has a
column named "PARTITION".  Partition is a SQL*Loader reserved word and the
load failed with: SQL*Loader-350 Expecting column name found "partition".

If anyone has a solution or workaround for this gotcha, I'd like to know
what you have done.

Thanks very much.

Michael L. Petrus
GE Auto Warranty Services
7125 W. Jefferson Av. #200
Lakewood, CO 80235

Database Administrator

Phone: (303) 987 4129
Fax: (303) 987 4298
Email:   [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Petrus, Mike  (CAP, GEFA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader reserved word is column name

[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 05, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L


Can anyone help?

I am attempting to load a table, using SQL*Loader, where the table has a
column named "PARTITION".  Partition is a SQL*Loader reserved word and the
load failed with: SQL*Loader-350 Expecting column name found "partition".

If anyone has a solution or workaround for this gotcha, I'd like to know
what you have done.

Thanks very much.

Michael L. Petrus
GE Auto Warranty Services
7125 W. Jefferson Av. #200
Lakewood, CO 80235

Database Administrator

Phone: (303) 987 4129
Fax: (303) 987 4298
Email:   [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Petrus, Mike  (CAP, GEFA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sqlloader reserved word is column name

[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 wrote:
PMCG> Can anyone help?

PMCG> I am attempting to load a table, using SQL*Loader, where the table has a
PMCG> column named "PARTITION".  Partition is a SQL*Loader reserved word and the
PMCG> load failed with: SQL*Loader-350 Expecting column name found "partition".

PMCG> If anyone has a solution or workaround for this gotcha, I'd like to know
PMCG> what you have done.

PMCG> Thanks very much.

PMCG> Michael L. Petrus
PMCG> GE Auto Warranty Services
PMCG> 7125 W. Jefferson Av. #200
PMCG> Lakewood, CO 80235

PMCG> Database Administrator

PMCG> Phone: (303) 987 4129
PMCG> Fax: (303) 987 4298
PMCG> Email:   [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader reserved word is column name

[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
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
-Original Message-
Sent: Tuesday, June 05, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L


Can anyone help?

I am attempting to load a table, using SQL*Loader, where the table has a
column named "PARTITION".  Partition is a SQL*Loader reserved word and the
load failed with: SQL*Loader-350 Expecting column name found "partition".

If anyone has a solution or workaround for this gotcha, I'd like to know
what you have done.

Thanks very much.

Michael L. Petrus
GE Auto Warranty Services
7125 W. Jefferson Av. #200
Lakewood, CO 80235

Database Administrator

Phone: (303) 987 4129
Fax: (303) 987 4298
Email:   [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Petrus, Mike  (CAP, GEFA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Petrus, Mike  (CAP, GEFA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).