ORACLE数据库备份转移时提示数据库编码不正确,如何在不重新安装oracle的前提下修改字符集。
SQL>STARTUP MOUNTSQL>ALTER SYSTEM ENABLE RESTRICTED SESSIONSQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0SQL>ALTER DATABASE OPENSQL>ALTER DATABASE CHARACTER SET ZHS16GBK