| ORA-01855: AM/A.M. or PM/P.M. required [message #124394] |
Fri, 17 June 2005 18:56  |
carlosca
Messages: 1
Registered: June 2005
|
Junior Member |
|
|
Hello,
When i'm using sqlldr (oracle 9i) with a comma delimited archive and i have a problem with the date format... i've tried a lot of things, and i think the way i am doing it is rigth, but it comes up with this error
Record 1: Rejected - Error on table BANINST1.SZSHRTTRMT, column SHRTTRM_ACTIVITY_DATE. ORA-01855: AM/A.M. or PM/P.M. required
the date in the row appears like this: 14/06/2005 10:19:57 a.m.
and the column definition in my ctl file looks like this: SHRTTRM_ACTIVITY_DATE DATE 'DD/MM/YYYY HH:MI:SS A.M.'
If i put: SHRTTRM_ACTIVITY_DATE DATE 'DD/MM/YYYY HH:MI:SS A.M./P.M.' it comes up with this error:
Record 1: Rejected - Error on table BANINST1.SZSHRTTRMT, column SHRTTRM_ACTIVITY_DATE.
ORA-01810: format code appears twice
so, the first error says A.M. is required, and the second one say that the format code appears twice... i dont get it...
What could be wrong with the format SHRTTRM_ACTIVITY_DATE DATE 'DD/MM/YYYY HH:MI:SS A.M.' ??
|
|
|
|
|
|
| Re: ORA-01855: AM/A.M. or PM/P.M. required [message #124472 is a reply to message #124394] |
Sat, 18 June 2005 22:05  |
 |
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
SHRTTRM_ACTIVITY_DATE DATE 'DD/MM/YYYY HH:MI:SS A.M.'
is the correct format in your control file for
14/06/2005 10:19:57 a.m.
in your data file.
The only way that I have been able to reproduce your error is if the data is different. For example, the following produces the error:
14/06/2005 10:19:57 XY
I suggest that you check your data carefully and see if some of it is in a different format.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
