(1)查看字符集(三条都是等价的)
复制代码 代码如下:
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)查看国家字符集(三条都是等价的)
复制代码 代码如下:
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)查看oracle server端的字符集
复制代码 代码如下:
select userenv(‘language’) from dual
(4)datafile操作
复制代码 代码如下:
–datafile联机
alter tablespace bss11 online
alter database ‘bss_03.dbf’ online
–datafile脱机
alter tablespace bss11 offline –作用对象:表空间bss11的所有datafile
alter database ‘bss_03.dbf’ offline —作用对象:bss_03.dbf,就一个datafile
–resize datafile
alter database datafile ‘bss_03.dbf’ resize 500m;