Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> NLS_PARAMETERS in 8?
Hi
I have just migrated a database from 7.3.3 to 8.0.5 It's running on NT4 w SP4.
I am loading data with SQLLDR.
In the data there are Price-columns, that is values with decimals.
The data comes with ',' as decimalseparator.
In 7.3.3 it worked fine, now in the 8.0.5
sqlldr80 protests about the price-column.
I've tried to set: NLS_TERRITORY = SWEDEN
(and also: NLS_ISO_CURRENCY = SWEDEN)
in the initDB.ora-file.
But it still doesn't work, and if i select * from v$nls_parameters I still have AMERICA and AMERICAN everywhere! What should I do?