ora-00910: specified length too long for its datatype 字元集不符

  • 322
  • 0

這個問題是屬於Oracle字元集不符的問題,在我docker上的oracle是 UTF-8,但我要匯入的資料庫來源卻是AL16UTF16,因此要先更改字元集,匯入db時才不會出現失敗

 

$sqlplus 'sys/oracle as sysdba'
SQL> SHUTDOWN IMMEDIATE; 
SQL> STARTUP 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 NATIONAL CHARACTER SET INTERNAL_USE UTF8; 
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;