Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr issue with decimal separator

892390Oct 4 2011 — edited Oct 10 2011
Hi 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2011
Added on Oct 4 2011
11 comments
8,619 views