oracle10g_csscan_更变数据库字符集及国家字符集的工具测试
1,先在转换字符集及国家字符集前作个数据库backup
2,csscan userid=system/system full=y
运行这个命令可能会提示
CSSCAN \"sys/password@db10g AS SYSDBA\" FULL=Y
Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Tue Dec 5 06:54:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
CSS-00107: Character set migration utility schema not installed
Scanner terminated unsuccessfully.
C:\>
3,解决以上运行以下：
The character set migration utility schema is installed by running the
"$ORACLE_HOME/rdbms/admin/csminst.sql" script. in SQL*Plus as the SYS
user.
4，然后再运行csscan userid=system/system full=y --此可以交互式或者提供相关参数
5,shutdown immediate
6,startup restrict
7,@@csalter.plb --$ORACLE_HOME/rdbms/admin
8,shutdown immediate
9,startup
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9240380/viewspace-614070/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- redhat要持续学习哟加加油
- 升级redhat 6.8 默认gdb 7.2到gdb 8.3.1操作指南
- redhat 6.8升级默认cmake 2.8到cmake 3.9
- mysql source code源代安装的前提条件requirement
- mysql handler语句之一
- mysql show open tables相关知识体系之一
- mysql snapshot read快照读及current read当前读与锁lock之一
- mysql 5.7 _rowid虚列之一
- mysql innodb lock锁之record lock之一
- mysql隐式提交事务transaction一点笔记
