Max Primary Key Value for Oracle 10g [message #335795] |
Wed, 23 July 2008 15:56 |
zenp25
Messages: 5 Registered: July 2008
|
Junior Member |
|
|
I have made a table in Oracle 10g with a primary key that has a varchar2 vlaue up to 1000 characters. Is there a maximum value on the primary key? I get errors on some data I am dumping into the table and I thought it might be because the value is over 255 charactes.
|
|
|
|
Re: Max Primary Key Value for Oracle 10g [message #335809 is a reply to message #335802] |
Wed, 23 July 2008 16:50 |
zenp25
Messages: 5 Registered: July 2008
|
Junior Member |
|
|
Thanks for the input. I am using sqlldr to steam thousands of records with a long primary key. The primary key is a string of about 300 charaters. The logfile reads: "Field in data file exceeds maximum length" even though the column is set to varchar2(1000). I looked at the .bad file and the rejected rows for the column data do not exceed 1000 characters.
I was wondering if anyone knows what the max primary key value is in Oracle 10g.
|
|
|
|
|
|
|
Re: Max Primary Key Value for Oracle 10g [message #336925 is a reply to message #335795] |
Tue, 29 July 2008 06:47 |
Arju
Messages: 1554 Registered: June 2007 Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
|
|
From Documentation about CHAR in SQL*LOADER,
Quote: |
If a length is not specified, it is derived from the POSITION specification.
If a length is specified, it overrides the length in the POSITION specification.
If no length is given and there is no POSITION specification, CHAR data is assumed to have a length of 1, unless the field is delimited:
For a delimited CHAR field, if a length is specified, that length is used as a maximum.
For a delimited CHAR field for which no length is specified, the default is 255 bytes.
For a delimited CHAR field that is greater than 255 bytes, you must specify a maximum length. Otherwise you will receive an error stating that the field in the datafile exceeds maximum length.
|
[Updated on: Tue, 29 July 2008 06:48] Report message to a moderator
|
|
|
|
|
|