Loader , gde gresim

[ dragancesu @ 10.02.2007. 13:27 ] @

Instalirao sam bazu 10gXE pa probam sve redom pa sada loader. Radi to ali imam problema sa ucitavanjem decimalnih brojeva. Evo i primera, nece. Karakter, integer, datum ucita kako god hoces, decimalne nece.

Pomoc. Kazite gde gresim

[ Dejan Topalovic @ 10.02.2007. 15:58 ] @

Vjerovatno imas problema sa NLS_NUMERIC_CHARACTERS parametrom.

Probaj jedan od ova dva nacina:

Code:
LOAD DATA
INFILE sqlldr02.dat
BADFILE 'badfile.txt'
DISCARDFILE 'discardfile.txt'
INTO TABLE emp
(empno    POSITION(01:04)        INTEGER EXTERNAL,
ename    POSITION(06:15)        CHAR,
job    POSITION(17:25)        CHAR,
mgr    POSITION(27:30)        INTEGER EXTERNAL,
sal    POSITION(32:39)        DECIMAL EXTERNAL "to_number(:sal,'9999D99','NLS_NUMERIC_CHARACTERS=''.,''')",
comm    POSITION(41:48)        DECIMAL EXTERNAL "to_number(:comm,'9999D99','NLS_NUMERIC_CHARACTERS=''.,''')",
deptno    POSITION(50:51)        INTEGER EXTERNAL)

ili

Code:
LOAD DATA
INFILE sqlldr02.dat
BADFILE 'badfile.txt'
DISCARDFILE 'discardfile.txt'
INTO TABLE emp
(empno    POSITION(01:04)        INTEGER EXTERNAL,
ename    POSITION(06:15)        CHAR,
job    POSITION(17:25)        CHAR,
mgr    POSITION(27:30)        INTEGER EXTERNAL,
sal    POSITION(32:39)        DECIMAL EXTERNAL "REPLACE(:sal,'.',',')",
comm    POSITION(41:48)        DECIMAL EXTERNAL "REPLACE(:comm,'.',',')",
deptno    POSITION(50:51)        INTEGER EXTERNAL)