Home » RDBMS Server » Server Utilities » sqlloader (10g)
sqlloader [message #509783] Wed, 01 June 2011 00:52 Go to next message
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 Go to previous message
Michel Cadot
Messages: 59421
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
Previous Topic: How do you import a database?
Next Topic: Estimate tablespace growth while loading data using sqlldr
Goto Forum:
  


Current Time: Wed Oct 22 22:49:44 CDT 2014

Total time taken to generate the page: 0.23449 seconds