Try: select * from v$nls_parameters;

BTW: Sure you don't want to change NATIONAL character set also?

ALTER DATABASE NATIONAL CHARACTER SET UTF8;?


"Shepard, Wade" wrote:

> I just recently did the following command
>
> SVRMGR> ALTER DATABASE CHARACTER SET UTF8;
>
> I know there is a V$ for NLS_CHARACTER SET is there on for Database
> Character set?
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page