cmd命令开始
sqlplus /nolog --访问sqlplus
connect /as sysdba --dba身份登陆
SHUTDOWN IMMEDIATE; --关闭数据库
select * from V$NLS_PARAMETERS; --查看数据库字符集
ORA-12899错误value too large for column
代码如下 复制代码
sys@PROD>SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@PROD>STARTUP MOUNT
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2233960 bytes
Variable Size 671091096 bytes
Database Buffers 260046848 bytes
Redo Buffers 6123520 bytes
Database mounted.
sys@PROD>ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
Elapsed: 00:00:02.19
sys@PROD>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
Elapsed: 00:00:00.02
sys@PROD>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
System altered.
Elapsed: 00:00:00.01
sys@PROD>ALTER DATABASE OPEN;
Database altered.
Elapsed: 00:00:05.09
sys@PROD>ALTER DATABASE CHARACTER SET ZHS16GBK ;
ALTER DATABASE CHARACTER SET ZHS16GBK
*
ERROR at line 1:
ORA-00911: 无效字符
Elapsed: 00:00:00.00
---报字符集不兼容，此时用INTERNAL_USE指令不对字符集超集进行检查
代码如下 复制代码
sys@PROD>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
Database altered.
