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. Whi
Hi All,
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 who
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 f
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 O
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 J
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 F
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
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
Should not be a problem:
sqlldr control= data=
userid=/@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, Ma
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
-Or
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 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 rev
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
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 s
$ 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 logi
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*
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 nu
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 rec
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
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 fi
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 Networ
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 spec
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 w
0 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
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 qu
-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 ??
>
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 crea
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
I’m 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
cont
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:
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
ething 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
I’m
usin
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://
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
You could consider doing someting like an awk script against your data
looking for UNIX in that field. Taking this data and piping it to a new
file to be loaded.
-Original Message-
Sent: Monday, July 30, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L
Thanks for the tips on the
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
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 bett
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 , E
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
ENCL
username/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 ques
inal.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
49 matches
Mail list logo