Uploading data through SQL Loader
652374Aug 19 2008 — edited Aug 20 2008I am trying to upload the data thru the Sqlldr but getting error as
"Record 1: Rejected - Error on table VALID_13082008_TEMP, column CREATED.ORA-01818: 'HH24' precludes use of meridian indicator"
My Control File structure is like
LOAD DATA
infile*
REPLACE
INTO TABLE VALID_13082008_TEMP
( CONTACT_ID char terminated by',',
ACCNT_ID char terminated by',',
NAME char terminated by',',
Account_Number integer external terminated by',',
BAN integer external terminated by',',
DIVISION char terminated by',',
Segment char terminated by',',
FST_NAME char terminated by',',
LAST_NAME char terminated by',',
EMAIL_ADDR char terminated by',',
WORK_PH_NUM char terminated by',',
LAST_UPD_BY char terminated by',',
CREATED DATE "MON DD YYYY HH24:MI:SSAM" terminated by',',
LAST_UPD DATE "MON DD YYYY HH24:MI:SSAM" terminated by',',
CONTACT_XM_ID char terminated by',',
Primary_Contact_Type char terminated by',',
Remarks char terminated by','
)
And Data File structure is like
7-CO9N0N,2-1FW-2711,ALLIANCE ROYALE,21868102421,000000000013855,5 SAS,Small Business,DON,SHRANK,123.don@allianceroyale.com,4082503476,7-K1-2070,6/12/2007 6:45:45 PM,10/11/2007 12:49:55 PM,7-CO9N0R,Primary Billing,Correct Email
2-1OM-264,2-1FW-884,AD FACTORY,2186810660,000006000000906,5 SAS,Small Business,ALLISON,HART,123.abh@adfactoryinc.com,6142281080w,7-K1-538,4/17/2002 3:56:28 PM,8/31/2007 11:44:43 AM,7-XM-1208149,Primary Site,Correct Email
2-1S0-4768,2-1FW-900,ADAMS JOHN MD/COWLEY COSMETIC CENTER,2186811664,000005000001767,5 SAS,Small Business,DIANE,ADAMS,123.dradams@q.com,5099794215,7-DJ6M1Z,4/18/2000 4:27:55 PM,5/30/2008 11:54:32 AM,7-XM-1367233,Primary Site,Correct Email
7-643IGQ,2-1FW-902,A.C. SINAGRA & ASSOC.,2186811666,000000000003707,5 SAS,Small Business,ELIZABETH,SELINKA,123.tony@acsinagra.com,2162212323,7-CCL570,12/17/2004 10:25:50 AM,5/30/2008 12:44:26 PM,7-XM-952365,Decision Maker,Correct Email
7-G2K69Q, ,COMMUNITY TRUST CO,218681297,000000000000839,5 SAS,Small Business,RHONDA,MOORE,123.rmoore@communitytrustco.com,7177319604,7-DJ6M1Z,4/15/2008 3:18:46 PM,4/15/2008 3:18:46 PM,7-G2K69U,Unauthorized,Correct Email
7-BI8F1,2-1FW-101,COMMUNITY TRUST CO,218681297,000000000000839,5 SAS,Small Business,SUE,RUSSELL,123.srussell@communitytrustco.com,7177319604,7-9041H7,1/29/2004 4:29:46 PM,10/18/2006 10:41:14 AM,7-XM-349313,Decision Maker,Correct Email
Please help me in sorting out this as i am a new user to SQL Loader.