Home » SQL & PL/SQL » SQL & PL/SQL » can alter nls_database_parameters table
can alter nls_database_parameters table [message #257298] Wed, 08 August 2007 01:13 Go to next message
srilaxmi
Messages: 16
Registered: June 2007
Location: hyderabad
Junior Member
hi all!


1. what is the difference between nls_database_parameters, nls_session_parameters and nls_instance_parameters?


2. can alter nls_database_parameters table
if YES how can do that?

let me know

thankyou,
regards
srilaxmi

[mod-edit] removed all IM words as they have the same effect as no words at all.

[Updated on: Wed, 08 August 2007 08:19] by Moderator

Report message to a moderator

Re: can u alter nls_database_parameters table [message #257313 is a reply to message #257298] Wed, 08 August 2007 01:29 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
link

MHE
Re: can u alter nls_database_parameters table [message #257314 is a reply to message #257298] Wed, 08 August 2007 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1.
database: defined at database level (at create time)
instance: defined at instance level (in configuration file pfile or spfile)
session: defined at session level (with environment variables or alter session)

2. No.

Regards
Michel
Re: can u alter nls_database_parameters table [message #257319 is a reply to message #257298] Wed, 08 August 2007 01:34 Go to previous message
reyazan
Messages: 53
Registered: February 2005
Member
The values in nls_database_parameters are the values that were set in
your init.ora at the time the database was created. The values in
nls_instance_parameters are the values that were set at the last
startup
Previous Topic: Re: ORA-06530: Reference to uninitialized collection
Next Topic: UTL
Goto Forum:
  


Current Time: Thu Dec 08 18:47:07 CST 2016

Total time taken to generate the page: 0.08293 seconds