• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2653
  • Last Modified:

Change NLS_NUMERIC_CHARACTERS On Existing DB

Howdy,

I was asked to do some data-mining on a DB which has it's decimal separator set as a comma.  This is mucking up many of my data-mining/statistical analysis programs in R, Perl, etc..   The users have no objections to me changing this setting globally, rather doing it on a per-session basis.  Can this be done, and how?  I was skimming Oracle docs, and they seemed to imply that you could only change it on a per-session basis or on database creation.

-Tats
0
Itatsumaki
Asked:
Itatsumaki
  • 3
1 Solution
 
DanielztCommented:

Oracle 9i
http://www.oracle-base.com/Articles/9i/DBNEWID.asp


Oracle 8i
Prior to the introduction of the DBNEWID utility, you could manually create a copy of a database and give it a new database name (DBNAME) by re-creating the control file.

this paper will show you the process.

http://www.dbaclick.com/forums/archive/16/35.html
0
 
DanielztCommented:
sorry. reply to wrong question.
0
 
DanielztCommented:
0
 
ItatsumakiAuthor Commented:
I solved this myself by adding wrapper code to all connection software to immediately do an ALTER SESSION after connecting.  Thanks, though.
-Tats
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now