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)
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA