OraFAQ Forum: Server Utilities » SQL loader null and datatype

Home » RDBMS Server » Server Utilities » SQL loader null and datatype

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL loader null and datatype [message #187210]

Fri, 11 August 2006 05:38

sanjit
Messages: 65
Registered: November 2001

Member

I have datafile like

2039386,GB4444,,NZD,12456.00-,,,04Feb02,,,GBP,3617.75-,0.2904424,03,2
2039380,GB5444,AT8000,NZD,123456789.00,07Mar02,INVOICE REFERNCE VVVVVVV,10Feb02,,,GBP,35857082.52,0.2904424,01,1
2039382,GB4444,AT8000,GBP,674.13,17Mar02,INVOICE REFERNCE,02Feb02,,,GBP,674.13,1,01,1

I am facing two issue
1. There is one field , which carry - sign , thus sqlloader rejects,the column does have datatype number(12,2) and in loader this datatype i decxlare is decimal external.

2. There is few column which does not have any data,thus they aslo get rejected

can anyone point, is there any way to bypass the null value against that column and what would be datatype for -ve sign value.

Third Does SKIP=1 means no lodaing for first row from data file

thanks in advance
regards
sanjit

Report message to a moderator

Previous Topic:	Error with SQL Loader import file in Oracle 10G
Next Topic:	Split record in SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:35:34 CST 2024