全部博文
-
编辑 删除
Oracle10g不重装数据库改字符集
$ isqlplusctl stop $ emctl stop dbconsole $ lsnrctl stop $ sqlplus /nolog SQL> conn sys / as sysdba SQL> shutdown immediate SQL> startup nomount SQL> alter database mount exclusive; 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 database character set internal_use zhs16gbk; SQL> shutdown immediate SQL> startup nomount SQL> alter da
