| sathish |
Posted: Dec 04, 2006 10:50:55 PM |
Total Post: 47
Joined: Mar, 2006
|
Hi anyone help me
I m trying to load data's that contains a column value like
'2006-08-12 17:34:23.456000000 '(date format).
table struct
col_name data type
req_date timestamp fraction 9
In control file ,i have specified
req_date timestamp 'yyy-mm-dd hh24:mi:ss'
but i got an error for all the rows
Record 1: Rejected - Error on table order, column req_date.
ORA-01830: date format picture ends before converting entire input string
regards
sathish |
|
|
maddy |
| Posted: Dec 05, 2006 11:40:07 PM | |
|
Total Post: 18
Joined: Aug, 2006
|
hi
change the datatype to timestamp(9)
example:
create table timee(ti timestamp(9));
insert into timee values('12-08-2006 17:34:23.456000000 ');
|
|
|
|
|
sathish |
| Posted: Dec 06, 2006 03:49:37 AM | |
|
Total Post: 47
Joined: Mar, 2006
|
its ok
I need in sql ldr control file not in simple insert st.
check in table struct format ....
date column (timestamp with fraction 9)
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |