這個問題是屬於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;