摘要:
[oracle@roger ~]$scan默认会将扫描相关的信息写入到一个试图scm$parameters中,查询如下:SQL> select * from csm$parameters;NAMEVALUE--------------------------------------------------------------------------------SCANNER_VERSION5SCAN_TYPEALLSCAN_CHARYESTO_CHARSET_NAMEZHS16GBKFROM_CHARSET_NAMEWE8ISO8859P1SCAN_NCHARNOMAX_ARRAY_ 阅读全文
摘要:
从上面的安装结果输出信息来看,下面的2条授权语句执行失败了,grant READ on directory log_file_dir to systemgrant READ on directory data_file_dir to system这两句授权的语句,是没什么用的,完全可以从scminst.sql脚本中删除,大家可以参考如下metalink文档:Installing and configuring Csscan in 10g and 11g(Database Character Set Scanner) [ID 745809.1]关于csscan的运用,大家可以查看帮助信息,可以进 阅读全文
摘要:
SQL> !uname -aLinux roger 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17EDT 2006 i686 i686 i386 GNU/LinuxSQL> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------AMERICAN_AMERICA.WE8ISO8859P1SQL> select * from v$version;BANN 阅读全文