-
SQL Loader
ctrl file
INTO TABLE UG_HISTORY
APPEND fields TERMINATED BY "#" optionally ENCLOSED BY '"' TRAILING NULLCOLS
(
UPDATEDT DATE 'YYYY-MM-DD HH24:MI:SS',
)
--------
dat file
>"2006-03-16 13:48:23.0"#
>"2006-03-16 13:50:37.0"#
>"2006-03-16 14:26:44.0"#
---------
LOG:
Record 1: Rejected - Error on table UG_HISTORY, column UPDATEDT.
ORA-01830: date format picture ends before converting entire input string
Record 2: Rejected - Error on table UG_HISTORY, column UPDATEDT.
ORA-01830: date format picture ends before converting entire input string
Record 3: Rejected - Error on table UG_HISTORY, column UPDATEDT.
ORA-01830: date format picture ends before converting entire input string
I do not understand in what problemma. help please
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|