Lisa,
A suggestion, and I hope it's not too late. :)
Change the datatype to varchar2. Phone numbers
are not actually numbers, they're character fields.
My rule of thumb is: if you don't do math on it, it
isn't a number.
Jared
On Thursday 30 August 2001 10:33, Koivu, Lisa wrote:
I'm
Title: RE: sql*loader datatype question
Hi David,
Know what... I casted the phone number and that field works fine. AFter dumping the data and looking at where it ended up I saw that I was cross-eyed and had my column numbers off by like 1 or 2. This gets really tedious with 100+ fields
Lisa, in the modeling world, unless you are performing a calculation(like
on phone number), i've always been told to make them character.
joe
[EMAIL PROTECTED] 08/30/01 01:33PM
I'm hitting a wall here. I'm trying to
load data into a large table. Two of the fields are phone numbers (10
Title: sql*loader datatype question
Lisa,
Try to specify 'BADFILE' when using SQL*LOADER, should help
you to find bad record.
From FM:
When SQL*Loader executes, it can create a file called a bad file or reject file in which it
places records that were rejected because of formatting errors
Title: RE: sql*loader datatype question
Yup, looked at that too. Unfortunately the record is 1500 characters long. That's a lot to just eyeball.
Thanks
-Original Message-
From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:31 PM
To: Multiple recipients
:[EMAIL PROTECTED]] Sent: Thursday, August
30, 2001 2:31 PM To: Multiple
recipients of list ORACLE-L Subject: Re: sql*loader datatype question
Lisa,
Try to specify 'BADFILE' when using SQL*LOADER,
should help you to find bad record.
From FM:
When SQL*Loader executes, it can
Lisa,
Is the field you are attempting to load the last field in the string? is the delimited
in place? The reason being is the EXTERNAL INTEGER data might be interpreted at char
including the space at the end of the string. That has bit me before and now all
non-numbers are enclosed in quotes.
Lisa,
Have you tried loading without specifying any datatype and length in the
control file? Just a thought...
Prakash
-Original Message-
Sent: Thursday, August 30, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L
I'm hitting a wall here. I'm trying to load data into a large
Lisa,
Can you show us the control file and a couple of lines of sample data? Are
you sure you don't have an unprintable character before/after the phone
number? Is this occurring for all the phone numbers?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Title: RE: sql*loader datatype question
Well noo it's fixed-length and I think I'd end up with a big jumble, wouldn't I? No delims in the file.
-Original Message-
From: Bala, Prakash [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:48 PM
To: Multiple recipients
Title: RE: sql*loader datatype question
Good explanation but no it's not
-Original Message-
From: Ron Rogers [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: sql*loader datatype question
Lisa,
Is the field
: Multiple recipients of list ORACLE-LSubject: Re:
sql*loader datatype question
Lisa, in the modeling world, unless you are performing a calculation(like
on phone number), i've always been told to make them character.
joe
[EMAIL PROTECTED] 08/30/01 01:33PM
I'm hitting a wall here
Anyway, what if you need to add some
non-domestic phone numbers?
Henry
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001
3:46 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: sql*loader datatype question
I agree
Title: RE: sql*loader datatype question
Lisa,
A .bad
file with the offending record should have been created when sqlloader abended.
Even at 1500 characters you should be able to eyeball the single bad record in a
good editor and figure out what values are in the phone number part
in the file.
-Original Message-
From: Bala, Prakash [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: sql*loader datatype question
Lisa,
Have you tried loading without specifying
15 matches
Mail list logo