?
Solved

Change NLS_NUMERIC_CHARACTERS On Existing DB

Posted on 2003-11-11
5
Medium Priority
?
2,622 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

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.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

752 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