Oracle Query Character Set statement sharing _oracle

(1) View character set (three is equivalent)

Copy Code code 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 is equivalent)

Copy Code code 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 on the Oracle server side

Copy Code code as follows:

Select Userenv (' language ') from dual

(4) DataFile operation

Copy Code code 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---object: bss_03.dbf, just one datafile

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