| sqlloader [message #509783] |
Wed, 01 June 2011 00:52  |
 |
bhavangowda
Messages: 23
Registered: May 2011
Location: bangalore
|
Junior Member |
|
|
LOAD DATA
INFILE 'C:\loadata\Copy of PM_MAS_MATERIAL_CATEGORY.csv'
BADFILE 'C:\loadata\emp.bad'
DISCARDFILE 'C:\loadata\emp.dsc'
INSERT INTO TABLE PM_MAS_MATERIAL_CATEGORY
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(MATERIAL_CATEGORY_ID,UCL,LCL,TXN_DATE TIMESTAMP "DD-MON-YY hh:mi:ss A.M.",TXN_USERID,MATERIALCATEGORYLOTID,PRODUCTTYPE,PRODUCTSUBTYPE,UOM)
control file of sqlloader
csv file data
Binder,5,-5,01-JUN-11 10:37:20:0 ,Arind,,Water Based Products,All,PBW
Error--->
Record 14: Discarded - all columns null.
Record 1: Rejected - Error on table PM_MAS_MATERIAL_CATEGORY, column TXN_DATE.
ORA-01855: AM/A.M. or PM/P.M. required
IF I USE ONLY 01-JUN-11 IN THE CSV IT WORKS FINE .....
BUT WHEN I ADD THE TIMESTAMP THINGS TROWING ERROR
GUIDE ME
|
|
|
|
| Re: sqlloader [message #509788 is a reply to message #509783] |
Wed, 01 June 2011 01:09  |
 |
Michel Cadot
Messages: 68454
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:TXN_DATE TIMESTAMP "DD-MON-YY hh:mi:ss A.M.",
Quote:ORA-01855: AM/A.M. or PM/P.M. required
Quote:,01-JUN-11 10:37:20:0 ,
Nothing that gives you a hint about the problem?
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
Regards
Michel
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
