重建控制文件吧,原来是什么编码的? 1. alter database backup controlfile to trace as 'd:\trace.ora'; 2. shutdown immediate; 3.startup nomount; 4.把d:\trace.ora里面的部分内容拷出来,里面应该是 类似 create controlfile set database "orcl" resetlogs ...... .... character set gh16gbk; 5. startup mount; 6.alter database open resetlogs;
2. shutdown immediate;
3.startup nomount;
4.把d:\trace.ora里面的部分内容拷出来,里面应该是 类似 create controlfile set database "orcl" resetlogs
......
....
character set gh16gbk;
5. startup mount;
6.alter database open resetlogs;
Oracle字符集的查看查询和Oracle字符集的设置修改