I know that there are several sql loader gurus on this list. I'm having
a problem loading data from a third party vendor. into what is
basically a LONG column
The file is ASCII, tab delimited. The specs on the input data say that
this particular column is a memo field (the originating
Rachel,
I do not claim to be a guru, but I do happen to have Jonathan's book
here.
The first thing is what field type are you using for this memo field?
The book says you should use CHAR for VARCHAR2, CHAR, LONG and other
related.
What error are you getting?
Can you post the lines from the
Stephen,
I was using CHAR for the LONG column the error is actually on the
field in the file FOLLOWING the LONG column... I was getting a message
that the data was too large. So I did the following and it seems to be
working, although I can't get it to work via direct path this way:
I
Bob Robert [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/26/2003 01:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:SQL*Loader Help -- Multiple
rows into single column
Gurus
Gurus,
I have a special scenario to load data into tables
with SQL*Loader.
My SQL Loader data is not fixed format. It changes
from time to time. But there is a good pattern about
the data. Data which starts with letter R
should go to table1 and data which starts with letter
Z should go to
Bob
If you were on Unix, I would suggest you have a script that split your
input file into multiple files using one of the Unix utilities, then
executed SQL*Loader against each of those. Since you are on Windows, perhaps
someone has a suggestion that will apply there. I know there are Windows
/2003 01:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:SQL*Loader Help -- Multiple rows into single column
Gurus,
I have a special scenario to load data into tables
with SQL*Loader.
My SQL Loader
Hallo all you gurus,
I have a question:
Is it possible that every time the sql loader script runs change the field names to
the field names specified in the file to be loaded.: The field names should be
different dates.
The next time the script sqlloader run sit will be a new field name,
Not directly, but a with little sed/awk/grep etc you
could turn a template control file into a version
ready for use.
hth
connor
--- [EMAIL PROTECTED] wrote: Hallo all you
gurus,
I have a question:
Is it possible that every time the sql loader
script runs change the field names to the
Thanks in advance for help, been lurking for a couple of weeks.
I am using sqlldr73.exe to load a text file into an oracle 7.3.2.1.1 table. Field
datatype is number(14,0). What is the correct statement in the tablename.clr file
that will correctly load the data.
The clr file info latest
Try:
SICK_ACCRUAL POSITION(569:583) integer external(14),
VAC_ACCRUAL POSITION(585:599) integer external(14)
Helen
"Johnston, Steve" [EMAIL PROTECTED] wrote:
Thanks in advance for help, been lurking for a couple of weeks.I am using sqlldr73.exe to load a text file into an oracle 7.3.2.1.1
Chaim,
Check out the sqlldr case studies on OTN. Ross has the right idea with
the NULLIF. Here's a general description from OTN:
Loading All-Blank Fields
Totally blank fields for numeric or DATE fields cause the record to be
rejected. To load one of these fields as null, use the
You might want to look into the 'defaultif' option in the control file.
Prakash
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
Maybe some could help me.
I'm having trouble trying to load a csv file with
Chaim,
Along these lines, can't you disable the not null constraint, load the
data, update the table/columns (UPDATE MY_TABLE SET THIS_COLUMN = 0
WHERE THIS COLUMN IS NULL) then re-enable the constraints?
David
Ron Rogers wrote:
Chaim,
If on the other hand the BLANK will not work properly
lto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 2:47 PMTo: Multiple recipients of list ORACLE-LSubject: SQL Loader Help in 8.1.6
Dear Experts:
This does not make any sense to me, can you help me out?
I have a control file to interpret the mainframe data and then write to my table in Oracle Dat
Dear Experts:
This does not make any sense to me, can you help me out?
I have a control file to interpret the mainframe data and then write to my table in Oracle Database.
The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2).
All
At 11:47 AM 3/23/01 -0800, you wrote:
The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2).
That looks like the internal representation for a signed number under COBOL. The least significant digit (LSD) is used to store the
2:47
PMTo: Multiple recipients of list ORACLE-LSubject: SQL
Loader Help in 8.1.6
Dear Experts:
This does not make any sense to me, can you help me out?
I have a control file to interpret the mainframe data and then write to my
table in Oracle Database.
The mainframe data looks like
18 matches
Mail list logo