clay111的备忘文章收集

oracle修改字符集过程(ZT)

                                      

公司美女DBA做的，我留一份以后备用

1.检查数据文件状态
select name,status from v$datafile;
select name,status from v$tempfile;
检查各个文件
select name from v$datafile;
select name from v$tempfile; 
select name from v$controlfile;
select member from v$logfile;

2.lsnrctl stop
3.shutdown immediate
4.cp /opt/oracle/oradata/lee/* /opt/oracle/bak/
cp /opt/oracle/oradata/test.dbf /opt/oracle/bak/
5.编辑.bash_profile
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

6.
SQL> startup mount
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> alter session set events '10046 trace name context forever,level 12';
SQL> alter database character set INTERNAL_USE ZHS16GBK
SQL>select name,value$ from props$ where name like '%NLS%';
7.建测试表
Create table temp_cindy_test_1(a varchar2(256));
insert into temp_cindy_test_1 values('镕');
insert into temp_cindy_test_1 values('zzz');
insert into temp_cindy_test_1 values('冯');
commit;
select * from cindy_test;

8.
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=10;
ALTER SYSTEM SET AQ_TM_PROCESSES=1;
alter system disable RESTRICTED session .
9.lsnrctl start
10.shutdown immediate
11.startup
12.exp system/ikangcngnu file=/opt/oracle/exp/full_dmp.dmp log=/opt/oracle/exp/full_dmp.log full=y buffer=65536 direct=y statistics=none
成功~！！！！~~~~

【作者: clay111】【访问统计:】【2006年09月22日 星期五 23:30】【 加入博采】【打印】