sqlldr issue with decimal separator
892390Oct 4 2011 — edited Oct 10 2011Hi all, I read all of the threads regarding this problem, but no one could fix this.
shp2sdo works FINE and creates a .ctl file with decimal point separated values.
sqlldr doesn't work, because it's not able to load the file generated from his "brother"
my .ctl file begins like this:
LOAD DATA
INFILE *
TRUNCATE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE PATRIMONIOFABBRICATIMAPPA
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS (
ID INTEGER EXTERNAL,
CODCOM NULLIF CODCOM = BLANKS,
CHIAVE NULLIF CHIAVE = BLANKS,
ETICHETTA NULLIF ETICHETTA = BLANKS,
FOGLIO,
NUMERO,
SHAPE_LENG,
SHAPE_AREA,
GEOM COLUMN OBJECT
(
SDO_GTYPE INTEGER EXTERNAL,
SDO_ELEM_INFO VARRAY TERMINATED BY '|/'
(X FLOAT EXTERNAL),
SDO_ORDINATES VARRAY TERMINATED BY '|/'
(X FLOAT EXTERNAL)
)
)
I don't want to replace '.' with ',', because my file is 2.5GB
There's no way to alter the session parameters (nls_numeric_characters), because the session begins and end INTO the .ctl file
A way to load this file without headaches MUST exist.
What can I do?