Solved

Change NLS_NUMERIC_CHARACTERS On Existing DB

Posted on 2003-11-11
5
2,579 Views
Last Modified: 2012-06-27
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
Comment
Question by:Itatsumaki
  • 3
5 Comments
 
LVL 8

Expert Comment

by:Danielzt
ID: 9725681

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
 
LVL 8

Expert Comment

by:Danielzt
ID: 9725886
sorry. reply to wrong question.
0
 
LVL 8

Expert Comment

by:Danielzt
ID: 9726124
0
 
LVL 2

Accepted Solution

by:
Itatsumaki earned 0 total points
ID: 9762087
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now