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
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.
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
Hi All,
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
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,
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,
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,
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
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,
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
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
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.
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
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
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
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
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
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
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
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
$ 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
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
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
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.
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
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
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.datINTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY , ENCLOSED BY (TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY ,
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
=/.../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
-
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
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
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
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
: 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
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
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
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
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
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
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
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
rk 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
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 *
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'
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
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
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
48 matches
Mail list logo
