Home » RDBMS Server » Server Utilities » SQL loader null and datatype
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
Previous Topic: Error with SQL Loader import file in Oracle 10G
Next Topic: Split record in SQL*Loader
Goto Forum:
  


Current Time: Sat Dec 03 13:41:32 CST 2016

Total time taken to generate the page: 0.10312 seconds