读书人

Oraclet命令行imp时报值太大(ORA-1289

发布时间: 2014-01-17 15:01:00 作者: rapoo

Oraclet命令行imp时报值太大(ORA-12899)的解决办法
SQL>select * from V$NLS_PARAMETERSSQL>conn / as sysdbaSQL>shutdown immediateSQL>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 ZHS16GBKSQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBKSQL>SHUTDOWN IMMEDIATESQL>STARTUP

?经过了以上的折腾,就解决了值太大的问题了。

?

读书人网 >其他数据库

热点推荐