Oracle Modified Character Set

Under Linux installed Oracle 11G, due to the installation time did not pay attention to the character set problem, IMPDP import operation after the Chinese garbled.

1. Use the command select Userenv (' language ') from dual; viewed normal Oracle and garbled Oracle characters, found to be simplified Chinese_china, respectively. Al32utf8 and the simplified Chinese_china. we8mswin1252, a character set we8mswin1252 error was found .

2. Modifying the character Set

>shutdown immediate; ( put database stop )

>startup Mount; (Re-open the database To change the situation )

>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 se  AL32UTF8;   ( or   &NBSP, >alter database Character set Internal_use Al32utf8;

>shutdown immediate;

>startup; (Re- open normal Oracle)

3. Perform the import operation

IMPDP jmkj/123456 directory=jmkjdir dumpfile=201611080000.dmp remap_schema=jmkj:jmkj logfile=impdp.log;

Error occurred

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and Real Application testing options ora-39006:internal Error ORA-39213:M Etadata processing is not available

4. Repair ora-39006,ora-39213

Sqlplus/as sysdba

sql> execute dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.sql> Exit

5. Import successfully again

IMPDP jmkj/123456 directory=jmkjdir dumpfile=201611080000.dmp remap_schema=jmkj:jmkj logfile=impdp.log;

Oracle Modified Character Set