How to import Oracle11g backup to 10g

How to import Oracle11g backup to 10g, 10g Import Statement: IMPDPUSERID

How to import Oracle 11g backup to 10g, 10g Import Statement: impdp userid =

2. Use the impdp command to restore data on a 10 Gb Server

Preparations: 1. Create a database 2. Create a tablespace 3. Create a user and authorize 4. Copy aa. dmp to the 10 Gb dpdump directory

-- Create a tablespace

Createtablespace TS_Facial datafile 'e: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ Facial. dbf' size 500 M autoextend on next50M;

-- Create a user

Create user Facial identified by FacialDefault tablespace TS_Facial;

-- Authorize the user

Grantconnect, resource, dba to Facial;

Place aa. dmp and aa. log in the E: \ oracle \ product \ 10.2.0 \ admin \ orcl \ dpdump directory

When using expdp, an error may be reported. The solution is found on metink and Gai.

The ORA-39213 Metadata processing not available.

Connectedto: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-Production

Withthe Partitioning, OLAP and Data Mining options

ORA-39006: internal error

ORA-39213: Metadata processing is not available.

MetalinkTo confirm that the problem is a known problem, perform the following steps:

Connect/as sysdba

Executesys. dbms_metadata_util.load_stylesheets;

In my system, the above process is valid:

OracleDatabase 10g Enterprise Edition Release 10.2.0.2.0-Production

Withthe Partitioning, OLAP and Data Mining options

SQL> exec dbms_metadata_util.load_stylesheets

PL/SQLprocedure successfully completed.

SQL> exit

After that, the export can be executed smoothly.