Solved

Change NLS_NUMERIC_CHARACTERS On Existing DB

Posted on 2003-11-11
5
2,587 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Can anyone please tell me what does below Stored Procedure does? 4 33
exp/imp 25 88
how to trim oracle sql sentence in unix 17 62
Oracle Listener Not Starting 11 54
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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…
Via a live example, show how to take different types of Oracle backups using RMAN.

808 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