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
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
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,
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
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
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
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
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
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
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'
33 matches
Mail list logo