Re: sql loader question

[Jonathan Gennick]

Thursday, July 3, 2003, 5:40:37 AM, you wrote:
bnini SQL*Loader reads a set of records from a file, generates INSERT
bnini commands,

This is the key right here. A conventional path load
generates INSERT statements. A direct path load does not. A
direct-path load passes preformatted blocks to the database.
The term direct path comes from the fact that SQL*Loader
(the client) formats a database block and sends it to the
server to be written directly to the disk. No SQL processing
is involved.

bnini Answer : Direct-path load , ( It is said free blocks which implies
bnini Direct-Path Load, because Conventional-Path Load also use
bnini partially filled blocks. )

Was this from an Oracle exam? I hope not. It's ironic the
person writing the test intended for you to notice the
subtle mention of free blocks when they themselves didn't
realize that direct path loads do not generate INSERT
statements.

bnini Shouldn't it be conventional path load, because insert commands are
bnini being used .

Yes. You are correct.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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).

sql loader question

[bulbultyagi]

Hello list I have a doubt regarding the following  question
:
**
SQL*Loader reads a set of records from a file, generates INSERT
commands, and passes them to the Oracle kernel. Oracle then finds
places for those records in free blocks in the table and updates any
associated indexes. Which SQL*Loader mode is used in this scenario?
A. direct-path load B. conventional path load

Answer : Direct-path load , ( It is said free blocks which implies
Direct-Path Load, because Conventional-Path Load also use
partially filled blocks. )
***
Shouldn't it be conventional path load, because insert commands are
being used .  Direct path load builds blocks of data in memory and
saves these blocks directly into the extents allocated for the table
being loaded

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: sql loader question

[Jared . Still]

Since direct path loads do an append, I would say the answer shown is 
incorrect.






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 07/03/2003 02:40 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:sql loader question


Hello list I have a doubt regarding the following  question
:
**
SQL*Loader reads a set of records from a file, generates INSERT
commands, and passes them to the Oracle kernel. Oracle then finds
places for those records in free blocks in the table and updates any
associated indexes. Which SQL*Loader mode is used in this scenario?
A. direct-path load B. conventional path load

Answer : Direct-path load , ( It is said free blocks which implies
Direct-Path Load, because Conventional-Path Load also use
partially filled blocks. )
***
Shouldn't it be conventional path load, because insert commands are
being used .  Direct path load builds blocks of data in memory and
saves these blocks directly into the extents allocated for the table
being loaded

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: 
  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).

SQL*LOADER question

[Rick_Cale]

Hi All,





  I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
  remote site (WAN connection) and another on my desk running the Oracle
  client software(no database). Can I, and if so how, use sqlldr on my  
  desktop PC to load data into the remote database. The data file to be 
  loaded and the control file are on my desktop. I do not want to use   
  netmeeting or PC anywhere type programs which I know I can use.   
 Thanks 
 Rick   






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

Re: SQL*LOADER question

[Igor Neyman]

Should not be a problem:

sqlldr control=your_ctl_file data=your_data_file
userid=login/pwd@remote_machine

where remote_machine is an entry in your local/client tnsnames file.


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 8:23 AM


 Hi All,





   I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
   remote site (WAN connection) and another on my desk running the Oracle
   client software(no database). Can I, and if so how, use sqlldr on my
   desktop PC to load data into the remote database. The data file to be
   loaded and the control file are on my desktop. I do not want to use
   netmeeting or PC anywhere type programs which I know I can use.
  Thanks
  Rick






 --
 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: Igor Neyman
  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: SQL*LOADER question

[Rachel Carmichael]

sqlldr username/[EMAIL PROTECTED] control=controlfilename 

I do it all the time

sqlnet works for all Oracle utilities (sqlldr, exp, imp)


--- [EMAIL PROTECTED] wrote:
 Hi All,
  
   
  
   
  
   
  
   
  
   
   I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i
 at a
   remote site (WAN connection) and another on my desk running the
 Oracle
   client software(no database). Can I, and if so how, use sqlldr on
 my  
   desktop PC to load data into the remote database. The data file to
 be 
   loaded and the control file are on my desktop. I do not want to use
   
   netmeeting or PC anywhere type programs which I know I can use.
   
  Thanks  
   
  Rick
   
  
   
  
   
 
 
 
 
 -- 
 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).
 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: SQL*LOADER question

[Deshpande, Kirti]

Sure, you can do it. 
Just use Oracle Net8 connect string to connect to the remote database when specifying 
userid for sqlldr. 

- Kirti 


-Original Message-
Sent: Wednesday, March 19, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L


Hi All,





  I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
  remote site (WAN connection) and another on my desk running the Oracle
  client software(no database). Can I, and if so how, use sqlldr on my  
  desktop PC to load data into the remote database. The data file to be 
  loaded and the control file are on my desktop. I do not want to use   
  netmeeting or PC anywhere type programs which I know I can use.   
 Thanks 
 Rick   



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: SQL*LOADER question

[Joseph S Testa]

Rick, am i missing something in the picture here??, why not use 
sqlloader(you'll need it on your local PC) and send it across sql*net?

joe


 Hi All,
   
  
   
  
   
  
   
  
   
  
   I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i 
at a
   remote site (WAN connection) and another on my desk running the 
Oracle
   client software(no database). Can I, and if so how, use sqlldr on 
my  
   desktop PC to load data into the remote database. The data file to 
be 
   loaded and the control file are on my desktop. I do not want to 
use   
   netmeeting or PC anywhere type programs which I know I can 
use.   
  
Thanks  
   
  
Rick
   
   
  
   
  
 
 
 
 
 -- 
 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).
 
 

Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  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: SQL*LOADER question

[Kevin Toepke]

Rick

You sure can -- as long as you can establish SQL*Net connection to the
instance on the remote machine. All you have to do is specify
[EMAIL PROTECTED] either on the command line or in your parameter
file.

If the OSs are exectly the same, you can even use direct path inserts

Kevin

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L


Hi All,





  I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
  remote site (WAN connection) and another on my desk running the Oracle
  client software(no database). Can I, and if so how, use sqlldr on my
  desktop PC to load data into the remote database. The data file to be
  loaded and the control file are on my desktop. I do not want to use
  netmeeting or PC anywhere type programs which I know I can use.
 Thanks
 Rick






--
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: Kevin Toepke
  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: SQL*LOADER question

[Schauss, Peter]

Rick,

Assuming sqlldr is installed on your client machine, you should
be able to run it locally.

HTH,
Peter Schauss

-Original Message-
Sent: Wednesday, March 19, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L


Hi All,





  I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a
  remote site (WAN connection) and another on my desk running the Oracle
  client software(no database). Can I, and if so how, use sqlldr on my  
  desktop PC to load data into the remote database. The data file to be 
  loaded and the control file are on my desktop. I do not want to use   
  netmeeting or PC anywhere type programs which I know I can use.   
 Thanks 
 Rick   






-- 
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: Schauss, Peter
  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).

Sql loader question

[Roland . Skoldblom]

Hallo
I am running this script but gets this errormessage: Why is it so?
I get the errormessage

 The system cannot find the file specified.(I:dvh\tuppy.txt)

but this file really exists: What is wrong. I include the textfile and also the ctl 
file.

(See attached file: nielsen.ctl)(See attached file: Tuppy.txt)

please check the files and see what is wrong.

Thanks in advance


Roland









nielsen.ctl
Description: Binary data


Tuppy.txt
Description: Text - character set unknown

RE: Sql loader question

[Mark Leith]

Roland

It should be I:\dvh\tuppy.txt

Amazing..

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 11 June 2002 12:58
To: Multiple recipients of list ORACLE-L


Hallo
I am running this script but gets this errormessage: Why is it so?
I get the errormessage

 The system cannot find the file specified.(I:dvh\tuppy.txt)

but this file really exists: What is wrong. I include the textfile and also
the ctl file.

(See attached file: nielsen.ctl)(See attached file: Tuppy.txt)

please check the files and see what is wrong.

Thanks in advance


Roland







-- 
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: Sql loader question

[Ganesh Raja]

You don't have a \ after I: That may be a Problem.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again. 




-Original Message-
Sent: Tuesday, June 11, 2002 3:58 PM
To: Multiple recipients of list ORACLE-L


Hallo
I am running this script but gets this errormessage: Why is it so? I get the
errormessage

 The system cannot find the file specified.(I:dvh\tuppy.txt)

but this file really exists: What is wrong. I include the textfile and also
the ctl file.

(See attached file: nielsen.ctl)(See attached file: Tuppy.txt)

please check the files and see what is wrong.

Thanks in advance


Roland






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ganesh Raja
  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: Sql loader question

[Alexandre Gorbatchev]

path problem. you set wrong.

  The system cannot find the file specified.(I:dvh\tuppy.txt)
try full path I:\dvh\tuppy.txt or I:/dvh/tuppy.txt

-- 
Alexandre
-- 
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: Sql loader question

[Toepke, Kevin M]

Did you, perchance, mean to specify I:\dvh\tuppy.txt?

-Original Message-
Sent: Tuesday, June 11, 2002 7:58 AM
To: Multiple recipients of list ORACLE-L


Hallo
I am running this script but gets this errormessage: Why is it so?
I get the errormessage

 The system cannot find the file specified.(I:dvh\tuppy.txt)

but this file really exists: What is wrong. I include the textfile and also
the ctl file.

(See attached file: nielsen.ctl)(See attached file: Tuppy.txt)

please check the files and see what is wrong.

Thanks in advance


Roland






-- 
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: SQL*Loader question

[KENNETH JANUSZ]

By default all records are loaded is only true if there are no errors.  The
default ERRORS is 50 which means that the load is automatically aborted when
50 records are rejected due to errors.  To assure that all records can be
loaded you need to set ERRORS to a higher number than the total number of
records in the load.

My $0.02 worth,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 11:28 PM


 The parameters LOAD and SKIP determine how many records to load and skip.
By
 default ALL records are loaded. HTH.

 Regards:
 Ferenc Mantfeld
 Senior Performance Engineer
 Siebel Performance Engineering
 Melbourne, 3000, VIC, Australia
  * +61-412-232-056
  * use mobile please
 Please note 17 hour time difference between Melbourne and CA


 -Original Message-
 Sent: Tuesday, 4 June 2002 8:39 AM
 To: Multiple recipients of list ORACLE-L


 Oracle 8.1.6.3 on Sun 2.6.

 I have tried reviewing the docs, but I didn't see anything that answered
the
 question.  Is it possible to limit the number of records being loaded?  We
 have a file that has records in the 6 digit range.  I'd like to test the
 controlfile, but I don't want to load the whole file.  Is there a way to
 tell loader to only load, say the 1st 100 records?

 TIA

 Terry Ball, DBA
 Birch Telecom
 Work: 816-300-1335
 FAX:  816-300-1800

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


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ferenc Mantfeld
   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: KENNETH 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).

SQL*Loader question

[Ball, Terry]

Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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: SQL*Loader question

[Seefelt, Beth]

I don't know if you can load the first 100 records, but you could load
the last 100 by setting the skip value to the total - 100.

HTH,

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered
the
question.  Is it possible to limit the number of records being loaded?
We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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).
--
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: SQL*Loader question

[Inder . Singh]

I don't know of any such option in sqlloader. But, you can do one thing copy
the 100 records from the file and create a new file and try to load that
one. Hope this helps.

Regards,
Inder

-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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).
-- 
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: SQL*Loader question

[Rachel Carmichael]

why not just create a smaller input file?

head -100 ...filename...  testfilename

and use the test file?



--- Ball, Terry [EMAIL PROTECTED] wrote:
 Oracle 8.1.6.3 on Sun 2.6.
 
 I have tried reviewing the docs, but I didn't see anything that
 answered the
 question.  Is it possible to limit the number of records being
 loaded?  We
 have a file that has records in the 6 digit range.  I'd like to test
 the
 controlfile, but I don't want to load the whole file.  Is there a way
 to
 tell loader to only load, say the 1st 100 records?
 
 TIA
 
 Terry Ball, DBA
 Birch Telecom
 Work: 816-300-1335
 FAX:  816-300-1800
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
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: SQL*Loader question

[DENNIS WILLIAMS]

Terry - Use Unix head command to create a small test file.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, June 04, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: SQL*Loader question

[Toepke, Kevin M]

$ sqlldr help=y
userid  ORACLE username/password
control Control file name
log Log file name
bad Bad file name
dataData file name
discard Discard file name
discardmax  Number of discards to allow
skipNumber of logical records to skip
loadNumber of logical records to load

-Original Message-
Sent: Tuesday, June 04, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L



I don't know if you can load the first 100 records, but you could load
the last 100 by setting the skip value to the total - 100.

HTH,

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered
the
question.  Is it possible to limit the number of records being loaded?
We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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).
-- 
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).
-- 
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: SQL*Loader question

[Gogala, Mladen]

It is supported on the machines that have implemented RPM 
instruction in their CPUs.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 04, 2002 12:08 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: SQL*Loader question
 
 
 
 I don't know of any such option in sqlloader. But, you can do 
 one thing copy
 the 100 records from the file and create a new file and try 
 to load that
 one. Hope this helps.
 
 Regards,
 Inder
 
 -Original Message-
 Sent: Tuesday, June 04, 2002 11:39 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Oracle 8.1.6.3 on Sun 2.6.
 
 I have tried reviewing the docs, but I didn't see anything 
 that answered the
 question.  Is it possible to limit the number of records 
 being loaded?  We
 have a file that has records in the 6 digit range.  I'd like 
 to test the
 controlfile, but I don't want to load the whole file.  Is 
 there a way to
 tell loader to only load, say the 1st 100 records?
 
 TIA
 
 Terry Ball, DBA
 Birch Telecom
 Work: 816-300-1335
 FAX:  816-300-1800
 
 -- 
 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).
 -- 
 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: Gogala, Mladen
  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: SQL*Loader question

[KENNETH JANUSZ]

Get a copy of SQL*Loader the Definitive Guide by Gennick  Mishra /
O'Reilly.

You can use command-line parameters in the control file via a the OPTIONS
command.  For example:

OPTIONS (parameter=value[,parameter=value...])

You can use:
SKIP=logical_record_count
LOAD=logical_record_count  (the number of records to load)
etc.

You can also extract the number of rows you want to load and place the data
in the control file.  Use the keyword BEGINDATA
data
data
data

My $0.02 worth,
Ken Janusz, CPIM


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 11:53 AM


 $ sqlldr help=y
 userid  ORACLE username/password
 control Control file name
 log Log file name
 bad Bad file name
 dataData file name
 discard Discard file name
 discardmax  Number of discards to allow
 skipNumber of logical records to skip
 loadNumber of logical records to load

 -Original Message-
 Sent: Tuesday, June 04, 2002 12:09 PM
 To: Multiple recipients of list ORACLE-L



 I don't know if you can load the first 100 records, but you could load
 the last 100 by setting the skip value to the total - 100.

 HTH,

 Beth

 -Original Message-
 Sent: Tuesday, June 04, 2002 11:39 AM
 To: Multiple recipients of list ORACLE-L


 Oracle 8.1.6.3 on Sun 2.6.

 I have tried reviewing the docs, but I didn't see anything that answered
 the
 question.  Is it possible to limit the number of records being loaded?
 We
 have a file that has records in the 6 digit range.  I'd like to test the
 controlfile, but I don't want to load the whole file.  Is there a way to
 tell loader to only load, say the 1st 100 records?

 TIA

 Terry Ball, DBA
 Birch Telecom
 Work: 816-300-1335
 FAX:  816-300-1800

 --
 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).
 --
 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).
 --
 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: KENNETH 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: SQL*Loader question

[Mercadante, Thomas F]

Terry,

Type SQLLDR at the command prompt, and all the help is displayed.

The answer to your question is :

sqlldr load=50  will load only 50 records.

Another option is to copy your data file and delete everything except for
the number of records to load for testing purposes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
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).
-- 
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: SQL*Loader question

[Ferenc Mantfeld]

The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL records are loaded. HTH.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
 * +61-412-232-056
 * use mobile please
Please note 17 hour time difference between Melbourne and CA


-Original Message-
Sent: Tuesday, 4 June 2002 8:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferenc Mantfeld
  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: SQL*Loader question

[Sinardy Xing]

Hi,

Why don't you just copy and paste those 100 records to other file and load from that 
new file.

Sinardy

-Original Message-
Sent: 05 June 2002 12:28
To: Multiple recipients of list ORACLE-L


The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL records are loaded. HTH.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
 * +61-412-232-056
 * use mobile please
Please note 17 hour time difference between Melbourne and CA


-Original Message-
Sent: Tuesday, 4 June 2002 8:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered the
question.  Is it possible to limit the number of records being loaded?  We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferenc Mantfeld
  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: Sinardy Xing
  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).

SQL*Loader question. Need a quick answer. Please

[Meomeo Nguyen]

 
 Meomeo Nguyen [EMAIL PROTECTED] wrote: 
Hi List,Below are my control and data files:(both files are stored on /Disk05)terminal.ctl file:LOAD DATAINFILE = ‘Disk05/terminal.dat’INTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”’(TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY “,” ENCLOSED BY ‘”’,TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY “,” ENCLOSED BY ‘”’,TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY “,”ENCLOSED BY ‘”’)terminal.dat file:A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package.B,Bottom,Terminals extend from the bottom of the package.D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows.for any reason, when entering sqlldr username/password control = /Disk05/terminal.ctl log =/Di!
sk05/terminal.log data =" '/Disk05/terminal.dat'an error message shows:segmentation fault.Alternatively, when issuing sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data =" '/Disk05/terminal.dat'an error message shows:lf iopn failed for file (terminal.log)Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated.ThanksTrang-Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTaxDo You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax

Re: SQL*Loader question. Need a quick answer. Please

[Ron Rogers]

Trang,
 I had a similar problem a while back and the answer was to have the
clause 
TERMINATED BY WHITESPACES as the option for the last column. Yours
continues to the next line because of the termination and enclosed
clause.
You might be confusing the load by saying it is TERMINATED BY and
ENCLOSED BY,
Which is it?
Ron
ROR mª¿ªm

 [EMAIL PROTECTED] 04/18/02 03:49PM 

 
  Meomeo Nguyen [EMAIL PROTECTED] wrote: 
Hi List,

Below are my control and data files:(both files are stored on /Disk05)

terminal.ctl file:

LOAD DATA
INFILE = 'Disk05/terminal.dat'
INTO TABLE TERMINAL_POSITION
FIELDS TERMINATED BY ',' ENCLOSED BY ''
(

TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY , ENCLOSED BY
'',
TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY , 
ENCLOSED BY '',
TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY ,
ENCLOSED BY ''
)

terminal.dat file:

A,Axial,Terminals extend from both ends in the direction of the major
axis of a cylindrical or elliptical package.
B,Bottom,Terminals extend from the bottom of the package.
D,Dual,Terminals are on opposite sides of a square or rectangular
package or located in two parallel rows.

for any reason, when entering 
sqlldr username/password control = /Disk05/terminal.ctl log
=/Disk05/terminal.log data = '/Disk05/terminal.dat'

an error message shows:
segmentation fault.

Alternatively, when issuing 
sqlldr userid = username/password control = /Disk05/terminal.ctl log
=/Disk05/terminal.log 
data = '/Disk05/terminal.dat'

an error message shows:

lf iopn failed for file (terminal.log)

Please note that: I did create terminal.log that is stored on /Disk05
as well. Please anyone point out what did I do wrong. Your help is
greatly appreciated.

Thanks
Trang



-
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax


-
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
--
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).

RV: SQL*Loader question. Need a quick answer. Please

[Natalia Laracca]

Hi, 
First, in a  test' database, I 
would do:

terminal.ctl

LOAD DATAINFILE 
'/.../terminal.dat'INTO TABLE TERMINALFIELDS TERMINATED BY 
','(TERMINAL_POSITION_ID ,TERMINAL_POSITION_NAME 
,TERMINAL_POSITION_DESCRIPTION)

terminal.sh

sqlldrusername/password control 
=/.../terminal.ctl errors=50
bad =/./terminal.bad log 
=/../terminal.log


Natalia L. Laracca

- Original Message - 
From: Meomeo Nguyen 

To: Multiple recipients of list ORACLE-L 
Sent: Thursday, April 18, 2002 4:49 PM
Subject: SQL*Loader question. Need a quick answer. 
Please


 Meomeo Nguyen [EMAIL PROTECTED] wrote: 
Hi 
  List,Below are my control and data files:(both files are stored on 
  /Disk05)terminal.ctl file:LOAD DATAINFILE = 'Disk05/terminal.dat'INTO TABLE TERMINAL_POSITIONFIELDS 
  TERMINATED BY ',' ENCLOSED BY '"'(TERMINAL_POSITION_ID VARCHAR2 
  TERMINATED BY "," ENCLOSED BY '"',TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY 
  "," 
  ENCLOSED BY '"',TERMINAL_POSITION_DESCRIPTION VARCHAR2 
  TERMINATED BY ","ENCLOSED BY '"')terminal.dat 
  file:A,Axial,Terminals extend from both ends in the direction of the 
  major axis of a cylindrical or elliptical package.B,Bottom,Terminals 
  extend from the bottom of the package.D,Dual,Terminals are on opposite 
  sides of a square or rectangular package or located in two parallel 
  rows.for any reason, when entering sqlldr username/password 
  control = /Disk05/terminal.ctl log =/Di! ! sk05/terminal.log data = 
 " '/Disk05/terminal.dat'<BR">an error message shows:segmentation 
  fault.Alternatively, when issuing sqlldr userid = 
  username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log 
  data =" '/Disk05/terminal.dat'<BR">an error message shows:lf 
  iopn failed for file (terminal.log)Please note that: I did create 
  terminal.log that is stored on /Disk05 as well. Please anyone point out what 
  did I do wrong. Your help is greatly 
  appreciated.ThanksTrang-Do 
  You Yahoo!?Yahoo! Tax Center - online filing with TurboTax


Do You Yahoo!?Yahoo! Tax Center - online 
filing with TurboTax

Re: RV: SQL*Loader question. Need a quick answer. Please

[Meomeo Nguyen]

 Hi All,
Thanks for allthe replies. I do appreciate it. Finally, Isuccessfully loaded data into the database, thanks toall your help.
Trang
 Natalia Laracca [EMAIL PROTECTED] wrote: 




Hi, 
First, in a test' database, I would do:

terminal.ctl

LOAD DATAINFILE '/.../terminal.dat'INTO TABLE TERMINALFIELDS TERMINATED BY ','(TERMINAL_POSITION_ID ,TERMINAL_POSITION_NAME ,TERMINAL_POSITION_DESCRIPTION)

terminal.sh

sqlldrusername/password control =/.../terminal.ctl errors=50
bad =/./terminal.bad log =/../terminal.log


Natalia L. Laracca

- Original Message - 
From: Meomeo Nguyen 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, April 18, 2002 4:49 PM
Subject: SQL*Loader question. Need a quick answer. Please


 Meomeo Nguyen [EMAIL PROTECTED] wrote: 
Hi List,Below are my control and data files:(both files are stored on /Disk05)terminal.ctl file:LOAD DATAINFILE = 'Disk05/terminal.dat'INTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY ',' ENCLOSED BY '"'(TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY "," ENCLOSED BY '"',TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY "," ENCLOSED BY '"',TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY ","ENCLOSED BY '"')terminal.dat file:A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package.B,Bottom,Terminals extend from the bottom of the package.D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows.for any reason, when entering sqlldr username/password control = /Disk05/terminal.ctl log =/Di! ! sk05/terminal.log data =" '/Disk05/terminal.dat'<BR">an error message shows:segmentation fault.Alternatively, when issuing sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data =" '/Disk05/terminal.dat'<BR">an error m!
!
essage shows:lf iopn failed for file (terminal.log)Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated.ThanksTrang-Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTax


Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTax Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax

RE: SQL Loader Question

[Deshpande, Kirti]

My guess is : No. 
Can you run a quick test and let us know ?? 
Thanks.
- Kirti 

-Original Message-
Sent: Wednesday, January 09, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L


8.1.7 on W2000
I would like to know if there is a way to group more than one parfile into
one file?  I would like to run just one file verses a number of parfiles.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
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).
-- 
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: SQL Loader Question

I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 4:30 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SQL Loader Question
 
 My guess is : No. 
 Can you run a quick test and let us know ?? 
 Thanks.
 - Kirti 
 
 -Original Message-
 Sent: Wednesday, January 09, 2002 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 8.1.7 on W2000
 I would like to know if there is a way to group more than one parfile into
 one file?  I would like to run just one file verses a number of parfiles.
 
 Thanks,
 Ken Janusz, CPIM 
 Database Conversion Lead 
 Sufficient Systems, Inc. 
 Minneapolis, MN
 
 -- 
 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).
 -- 
 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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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: SQL Loader Question

[Deshpande, Kirti]

Thank you very much

- Kirti 

-Original Message-
Sent: Thursday, January 10, 2002 10:51 AM
To: Multiple recipients of list ORACLE-L


I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 4:30 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SQL Loader Question
 
 My guess is : No. 
 Can you run a quick test and let us know ?? 
 Thanks.
 - Kirti 
 
 -Original Message-
 Sent: Wednesday, January 09, 2002 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 8.1.7 on W2000
 I would like to know if there is a way to group more than one parfile into
 one file?  I would like to run just one file verses a number of parfiles.
 
 Thanks,
 Ken Janusz, CPIM 
 Database Conversion Lead 
 Sufficient Systems, Inc. 
 Minneapolis, MN
 
 -- 
 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).
 -- 
 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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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: 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: SQL Loader Question

[Ron Rogers]

Ken,
You could create a batch file that references each par 
file and then run the batch file.
ex:
file :testexp.bat contains the following lines;
exp login/passwd@server parfile=location and 
name of parfile1

exp login/passwd@server parfile=location and 
name of parfile2
etc.
then just execute the testexp.bat file.
Works good under Novell.
ROR mª¿ªm [EMAIL PROTECTED] 
01/10/02 11:50AM I tested under 8.1.6 on NT and the reply is 
NO.Checked also the new features for 9.0.1 and no mention of 
this.Yechiel Adar, Mehish Computer 
Services[EMAIL PROTECTED] -Original Message- 
From: Deshpande, Kirti 
[SMTP:[EMAIL PROTECTED]] Sent: Thu, January 
10, 2002 4:30 PM To: Multiple recipients of list 
ORACLE-L Subject: RE: SQL Loader Question 
 My guess is : No.  Can you run a quick test and let us know ?? 
 Thanks. - Kirti   -Original 
Message- Sent: Wednesday, January 09, 2002 3:45 PM To: 
Multiple recipients of list ORACLE-L   8.1.7 on 
W2000 I would like to know if there is a way to group more than one 
parfile into one file? I would like to run just one file verses a 
number of parfiles.  Thanks, Ken Janusz, CPIM  
Database Conversion Lead  Sufficient Systems, Inc.  Minneapolis, 
MN  --  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). --  
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). 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This 
e-mail was scanned by the eSafe Mail Gateway  
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
=?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: SQL Loader Question

[Ken Janusz]

Ron:



That's
great, I'll give it a try.



Thanks,

Ken



-Original
Message-
From: Ron Rogers
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002
12:23 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: SQL Loader Question



Ken,

You could create a batch file that references each par file
and then run the batch file.

ex:

file :testexp.bat contains the following lines;

exp login/passwd@server
parfile=location and name of parfile1

exp login/passwd@server
parfile=location and name of parfile2

etc.

then just execute the testexp.bat file.

Works good under Novell.

ROR mª¿ªm



 [EMAIL PROTECTED] 01/10/02 11:50AM 
I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Deshpande, Kirti
[SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 4:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: SQL Loader Question
 
 My guess is : No. 
 Can you run a quick test and let us know ?? 
 Thanks.
 - Kirti 
 
 -Original Message-
 Sent: Wednesday, January 09, 2002 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 8.1.7 on W2000
 I would like to know if there is a way to group more than one parfile into
 one file? I would like to run just one file verses a number of
parfiles.
 
 Thanks,
 Ken Janusz, CPIM 
 Database Conversion Lead 
 Sufficient Systems, Inc. 
 Minneapolis, MN
 
 -- 
 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).
 -- 
 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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 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).

SQL Loader Question

[Ken Janusz]

8.1.7 on W2000
I would like to know if there is a way to group more than one parfile into
one file?  I would like to run just one file verses a number of parfiles.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

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

SQL Loader Question

[Ken Janusz]

I have two control files.  Each file loads from a different flat file to a
series of Oracle (8.1.7) tables.  Is there a way I can place both of these
files together into one control file or on parfile?  

Thanks,
Ken
-- 
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).

SQL*LOADER question.

[Ron Rogers]

List,
OS Novell 4.2  Oracle 7.3.4.5
I have a table test desc as fld1 number(5,3), fld2 varchar2(1). 
The control file has ,(comma) delimited, optionally enclosed in  (quotes).
 The data file contains 99.999,C 
It fails with an ORA-01401: inserted value to large for column.
Question. Why did Oracle show an ORA-01401 when the problem is the C value was not 
enclosed in quotes. I change the data to be 99.999,C and it loads properly.
 I would have thought that it would display something to the effect that I was trying 
to insert a non quoted value into a character field.
Any thoughts or ideas? 
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).

Re[2]: SQL*Loader question- Transforming Data

[Jonathan Gennick]

David,

SQL*Loader probably can't help here, because, unfortunatly,
the WHEN clause is not nearly as flexible as a SQL WHERE
clause. If no other solution presents itself, you could load
the data into a work table and write some PL/SQL code to
filter out the records that you don't want. You're better
of, though, if you can preprocess the file and remove the
records you don't want before you even load the data into
the database.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Monday, July 30, 2001, 6:30:51 PM, you wrote:
DW Thanks for the tips on the 'when' clause.  I guess my dilemma is that my
DW FLAG_TEXT is not the only part of the field I want to filter on.  For
DW example, let's say I want to filter out all the transactions containing the
DW word UNIX.

DW aaa,bbb,UNIX45689-2,ccc,ddd

DW In this case, I cannot use the 'when' clause like:

DW when (field  'UNIX')

DW I would need something equivalent to the SQL convention of not like 'UNIX%'
DW  with the % wildcard.  It appears that the 'when' clause is very limited in
DW this respect.  Any suggestions on filtering out part of the text string?

-- 
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: SQL*Loader question- Transforming Data

[Scott Canaan]

You could try:

when (9:12)  'UNIX'

However, this will only work if you have fixed field lengths in the input file.

Jonathan Gennick wrote:

 David,

 SQL*Loader probably can't help here, because, unfortunatly,
 the WHEN clause is not nearly as flexible as a SQL WHERE
 clause. If no other solution presents itself, you could load
 the data into a work table and write some PL/SQL code to
 filter out the records that you don't want. You're better
 of, though, if you can preprocess the file and remove the
 records you don't want before you even load the data into
 the database.

 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

 Monday, July 30, 2001, 6:30:51 PM, you wrote:
 DW Thanks for the tips on the 'when' clause.  I guess my dilemma is that my
 DW FLAG_TEXT is not the only part of the field I want to filter on.  For
 DW example, let's say I want to filter out all the transactions containing the
 DW word UNIX.

 DW aaa,bbb,UNIX45689-2,ccc,ddd

 DW In this case, I cannot use the 'when' clause like:

 DW when (field  'UNIX')

 DW I would need something equivalent to the SQL convention of not like 'UNIX%'
 DW  with the % wildcard.  It appears that the 'when' clause is very limited in
 DW this respect.  Any suggestions on filtering out part of the text string?

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

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  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).

SQL*Loader question- Transforming Data

[David Wagoner]

Im using SQL*Loader to populate a database table with transaction
records. The data file contains
some transactions that I want to exclude from the load and they all contain the
same text string, something like xxx,yyy,FLAG_TEXT,xxx,yyy. Can I use a SQL statement in the SQL*Loader
control file to filter out those transactions? Something that functions like this pseudocode:



if field like %FLAG_TEXT% then null;

else load;





Ive been reading the new Oracle SQL*Loader book by Gennick and Mishra
which is a good book, but Im still uncertain about this.





Thanks,



David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide Inc.

4815 Emperor
Blvd., Suite 110

Durham, NC
27703

Tel. (919)
941-4645

Fax (919)
474-0695

Email mailto:[EMAIL PROTECTED]

Web http://www.arsenaldigital.com/




*** NOTICE ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer. Thank you.

RE: SQL*Loader question- Transforming Data

[Mercadante, Thomas F]

Dave,

How 
about

INTO TABLE PROJ
FIELDS TERMINATED BY "," OPTIONALLY 
ENCLOSED BY '"' 
WHENFLAG_TXT != 'yourstringhere'
(EMPNO, ENAME, FLAG_TXT)

Look 
at the sample ULCASE5.ctl that is in the ORACLE_HOME\RDBMS\DEMO 
directory.

Looks 
like it is something that would work for you.
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: David Wagoner 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 30, 2001 
  2:56 PMTo: Multiple recipients of list ORACLE-LSubject: 
  SQL*Loader question- Transforming Data
  
  Im 
  using SQL*Loader to populate a database table with transaction records. The data file contains some 
  transactions that I want to exclude from the load and they all contain the 
  same text string, something like xxx,yyy,FLAG_TEXT,xxx,yyy. Can I use a SQL statement in the 
  SQL*Loader control file to filter out those transactions? Something that functions like this 
  pseudocode:
  
  if 
  field like %FLAG_TEXT% then null;
  else 
  load;
  
  
  Ive 
  been reading the new Oracle SQL*Loader book by Gennick and Mishra which is a 
  good book, but Im still uncertain about 
  this.
  
  
  Thanks,
  
  David B. 
  Wagoner
  Database 
  Administrator
  Arsenal 
  Digital Solutions Worldwide Inc.
  4815 
  Emperor Blvd., Suite 110
  Durham, 
  NC 27703
  Tel. 
  (919) 941-4645
  Fax 
  (919) 474-0695
  Email 
  mailto:[EMAIL PROTECTED]
  Web 
  http://www.arsenaldigital.com/
  
   
  *** NOTICE ***
  This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, work product or exempt from 
  disclosure under applicable law. 
  If you have received this message in error, or are not the named 
  recipient(s), please immediately notify the sender at (919) 941-4645 and 
  delete this e-mail message from your computer. Thank you.
  

Re: SQL*Loader question- Transforming Data

[Jonathan Gennick]

Hello David,

You need to use the WHEN clause. Look at the example in the
middle of page 147. If an input record doesn't match the
conditions you specify following WHEN, it simply isn't
loaded.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Monday, July 30, 2001, 2:56:22 PM, you wrote:
DW I'm using SQL*Loader to populate a database table with transaction records.
DW The data file contains some transactions that I want to exclude from the
DW load and they all contain the same text string, something like
DW xxx,yyy,FLAG_TEXT,xxx,yyy.  Can I use a SQL statement in the SQL*Loader
DW control file to filter out those transactions?  Something that functions
DW like this pseudocode:
 
DW if field like '%FLAG_TEXT%' then null;
DW else load;
 
 
DW I've been reading the new Oracle SQL*Loader book by Gennick and Mishra which
DW is a good book, but I'm still uncertain about this.
 
 
DW Thanks,
 
DW David B. Wagoner
DW Database Administrator
DW Arsenal Digital Solutions Worldwide Inc.
DW 4815 Emperor Blvd., Suite 110
DW Durham, NC 27703
DW Tel. (919) 941-4645
DW Fax (919) 474-0695
DW Email  mailto:[EMAIL PROTECTED]
DW mailto:[EMAIL PROTECTED]
DW Web  http://www.arsenaldigital.com/ http://www.arsenaldigital.com/
 
 
DW ***  NOTICE  ***
DW This e-mail message is confidential, intended only for the named
DW recipient(s) above and may contain information that is privileged, work
DW product or exempt from disclosure under applicable law.  If you have
DW received this message in error, or are not the named recipient(s), please
DW immediately notify the sender at (919) 941-4645 and delete this e-mail
DW message from your computer.  Thank you.

-- 
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: SQL*Loader question- Transforming Data

[David Wagoner]

Thanks for the tips on the 'when' clause.  I guess my dilemma is that my
FLAG_TEXT is not the only part of the field I want to filter on.  For
example, let's say I want to filter out all the transactions containing the
word UNIX.

aaa,bbb,UNIX45689-2,ccc,ddd

In this case, I cannot use the 'when' clause like:

when (field  'UNIX')

I would need something equivalent to the SQL convention of not like 'UNIX%'
 with the % wildcard.  It appears that the 'when' clause is very limited in
this respect.  Any suggestions on filtering out part of the text string?


TIA,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0695
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Monday, July 30, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L

Hello David,

You need to use the WHEN clause. Look at the example in the
middle of page 147. If an input record doesn't match the
conditions you specify following WHEN, it simply isn't
loaded.

Best regards,

Jonathan Gennick  
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Monday, July 30, 2001, 2:56:22 PM, you wrote:
DW I'm using SQL*Loader to populate a database table with transaction
records.
DW The data file contains some transactions that I want to exclude from the
DW load and they all contain the same text string, something like
DW xxx,yyy,FLAG_TEXT,xxx,yyy.  Can I use a SQL statement in the
SQL*Loader
DW control file to filter out those transactions?  Something that functions
DW like this pseudocode:

DW if field like '%FLAG_TEXT%' then null;
DW else load;


DW I've been reading the new Oracle SQL*Loader book by Gennick and Mishra
which
DW is a good book, but I'm still uncertain about this.


DW Thanks,

DW David B. Wagoner
DW Database Administrator
DW Arsenal Digital Solutions Worldwide Inc.
DW 4815 Emperor Blvd., Suite 110
DW Durham, NC 27703
DW Tel. (919) 941-4645
DW Fax (919) 474-0695
DW Email  mailto:[EMAIL PROTECTED]
DW mailto:[EMAIL PROTECTED]
DW Web  http://www.arsenaldigital.com/ http://www.arsenaldigital.com/


DW ***  NOTICE  ***
DW This e-mail message is confidential, intended only for the named
DW recipient(s) above and may contain information that is privileged, work
DW product or exempt from disclosure under applicable law.  If you have
DW received this message in error, or are not the named recipient(s),
please
DW immediately notify the sender at (919) 941-4645 and delete this e-mail
DW message from your computer.  Thank you.

--
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).
-- 
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: Urgenr : Sql Loader Question

[Nirmal Kumar Muthu Kumaran]

Hi friend,

i didn't succeed it with the format X'9' for the datafile delemited by
'tab'.

Could u help me in this.

the followin is the control file of mine:
load data 
infile *
into table abba1
fields terminated by X'9'
(a,b)
begindata
2384'vnb'
398489  'dke'

create table abba1(a number, b varchar2(30));

Nirmal.

 -Original Message-
 From: Darlene Marley [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, June 08, 2001 1:21 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Urgenr : Sql Loader Question
 
 FIELDS TERMINATED BY X'9'
 
  Chowdary, Suren wrote:
  
  How wud i load a TAB delimited data file through SQL*Loader into a
  Table.
  
  Like i use FIELDS TERMINATED BY , (for a comma seperated data file)
  
  what shud i use for TAB delimited file...
  
  Thanx for ur help,
  Chowday  File: Card for Darlene Marley  
-- 
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).

Re: Urgenr : Sql Loader Question

[Darlene Marley]

FIELDS TERMINATED BY X'9'

 Chowdary, Suren wrote:
 
 How wud i load a TAB delimited data file through SQL*Loader into a
 Table.
 
 Like i use FIELDS TERMINATED BY , (for a comma seperated data file)
 
 what shud i use for TAB delimited file...
 
 Thanx for ur help,
 Chowday

begin:vcard 
n:Marley;Darlene
tel;fax:561-682-0100
tel;work:561-682-2172
x-mozilla-html:FALSE
url:[EMAIL PROTECTED]
org:South Florida Water Management District;Everglades Department
adr:;;3301 GunClub Rd;West Palm Beach;Florida;33416;USA
version:2.1
email;internet:[EMAIL PROTECTED]
title:Specialist Systems Analyst/Programmer
fn:Darlene Marley
end:vcard

Urgenr : Sql Loader Question

[Chowdary, Suren]

Title: Urgenr : Sql Loader Question





How wud i load a TAB delimited data file through SQL*Loader into a Table.


Like i use FIELDS TERMINATED BY , (for a comma seperated data file)


what shud i use for TAB delimited file...


Thanx for ur help,
Chowday