Oralce中IMP数据库导入,字符集不相符的修改.

1.首先查看Oracle的字符集.
select * from nls_database_parameters;

2.按如下步骤进行修改.

connect system/admin as sysdba
shutdown immediate
startup mount
alter system enable restricted session;
alter system set JOB_QUEUE_PROCESSES=0;
alter system set AQ_TM_PROCESSES=0;
alter database open;
alter database character set internal_use JA16SJIS;
shutdown immediate
startup

注:从Oracle8i导入到OracleXE时,修改之后NLS_NCHAR_CHARACTERSET 仍然不同,按如下可进行修改,但修改之后数据库会被破坏,不能使用.建议初学者千万不要进行此操作.从Oracle8i导入到OracleXE,目前仍没有办法实现.

update props$ set value$='AL32UTF8'
where name = 'NLS_NCHAR_CHARACTERSET'