Re: Charset database was created with

"Andreas Boehm" <boehm_at_staware.com> wrote in message news:3C6549C9.D65C9B9B_at_staware.com...
> Hello,
>
> how do one determine with which character set the database was created?
> I do not
> mean the national charsets for nchar, but the character set given in the
> create
> database statement.
> Are there other solutions than reading the create database statement in
> the
> old alertlog? (What if the old log is lost?)
>
> thanx in advance,
> Andreas Boehm

select * from nls_database_parameters or select * from sys.props$

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address