i know i can find it by looking in the trace file that ALTER DATABASE BACKUP CONTROLFILE TO TRACE generates... isn't there a view i can find it in? i can't remember.
thx, d.
Printable View
i know i can find it by looking in the trace file that ALTER DATABASE BACKUP CONTROLFILE TO TRACE generates... isn't there a view i can find it in? i can't remember.
thx, d.
SELECT * FROM nls_database_parameters WHERE parameter= 'NLS_CHARACTERSET';
SQL> select value from v$nls_parameters
2 where parameter = 'NLS_CHARACTERSET';
VALUE
------------------------------
WE8ISO8859P1
thanks! i had trouble tracking it down.
d.