Oracle Query Character Set statement

(1) View character set (three are equivalent)

Copy CodeThe code is as follows:
SELECT * from v$nls_parameters where parameter= ' Nls_characterset '
SELECT * from nls_database_parameters where parameter= ' Nls_characterset '
SELECT * from props$ where name= ' Nls_characterset '

(2) View the national character set (three are equivalent)

Copy CodeThe code is as follows:
SELECT * from nls_database_parameters where parameter= ' Nls_nchar_characterset '
SELECT * from nls_database_parameters where parameter= ' Nls_nchar_characterset '
SELECT * from props$ where name= ' Nls_nchar_characterset '

(3) View the character set of the Oracle server side

Copy CodeThe code is as follows:
Select Userenv (' language ') from dual

(4) DataFile operation

Copy CodeThe code is as follows:

--datafile Online
ALTER tablespace BSS11 ONLINE
ALTER DATABASE ' bss_03.dbf ' online--datafile offline
ALTER tablespace BSS11 OFFLINE-Action object: All datafile of table space BSS11
ALTER DATABASE ' BSS_03.DBF ' OFFLINE---Action object: bss_03.dbf, just a datafile

--resize datafile
ALTER DATABASE datafile ' bss_03.dbf ' RESIZE 500M;

Oracle Query Character Set statement