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."

Oracle LazyDBA home page