Shulou(Shulou.com)06/01 Report--

As a programmer, I often encounter some strange things. Today, I came across one, oracle data imported through the data pump impdp, garbled, after the following operations:

1.oracle server character set query:

Select userenv ('language') from dual

It is found that the result of the check is not consistent with that of my original derived data.

The result of the original exported database is: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

The result of the new data is: SIMPLIFIED CHINESE_CHINA.WE8ISO8859P1

2.server character set modification

Change the character set step method (WE8ISO8859P1-- > ZHS16GBK)

Log in to the linux server where oracle is located and install the user through oracle (database installation)

After logging in, log in to sqlplus as an administrator

SQL > conn / as sysdba

SQL > shutdown immediate

SQL > startup mount

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 character set INTERNAL_USE ZHS16GBK

Database altered.

SQL > shutdown immediate

SQL > startup

Check the login system again and find that:

There was this angry way, so I was drunk, and then I decided to re-import the data:

3. Data pump import command:

(1) .oracle creates directory:

Create directory name as' path'

Drop directory name

For example: create directory bbsp_tmp as'/ home/app'

(2) execute under linux:

Directory= name (already created), and store the dmp file under this path

Impdp Import Database user / Import Database password directory= name (created) dumpfile=*.dmp (dmp file) remap_schema= original export file user name: import data user name

Example: impdp bbspzhun/bbspzhun directory=bbsp_tmp dumpfile=bbsp20181121.dmp remap_schema=bbsp:bbspzhun

As a result, this problem occurs again: expdp encounters an ora-39006 error when exporting data, and the error prompt is as follows

ORA-39006: internal error

ORA-39213: Metadata processing is not available

4. Resolve ORA-39006: internal error issues:

SQL > execute dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.****

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.