select * from nls_database_parameters;
should do the job
HAnS
-----Original Message-----
From: Mugasundaram Shan
[mailto:oracledba-ezmlmshield-x2940424.[Email address protected]
Sent: woensdag 1 maart 2006 15:58
To: LazyDBA Discussion
Subject: character set
Anyone tell me
How to get the following information for the running database instance.
CHARACTER SET ?
NATIONAL CHARACTER SET ?
I need to use this information to create other database. If possible is
there any way I can generate the create database script for the running
instance.
thanks
"The information in this e-mail and in any attachments is confidential
and intended solely
for the attention and use of the named addressee(s). This information
may be subject to legal,
professional or other privilege and further distribution of it is
strictly prohibited without
our authority. If you are not the intended recipient, you are not
authorised to and must not
disclose, copy, distribute, or retain this message or any part of it,
and should notify us
immediately.
This footnote also confirms that this email has been automatically
scanned for the presence
of computer viruses, profanities and certain file types."
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
Oracle LazyDBA home page