Solved

Change NLS_NUMERIC_CHARACTERS On Existing DB

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

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

706 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

21 Experts available now in Live!

Get 1:1 Help Now