This discussion is archived
10 Replies Latest reply: Apr 20, 2013 1:43 PM by 593460 RSS

Does Oracle 11g Express Edition 11.2.0.0 support the impdp utility ?

593460 Newbie
Currently Being Moderated
Hi,

We are trying to import an Oracle dump within a Express Edition, without success. We got the error message: ORA-39213: Metadata processing is not available.

A) Source data base: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
B) Target data base: Oracle Database 11g Express Edition Release 11.2.0.2.0

Searching for solution led us to following forum entries:

1. http://kmpdba.wordpress.com/2012/05/02/ora-39213-metadata-processing-is-not-available/ Cause: DBMS_METADATA_UTIL package does not successfully ran. Solution: to install (among others) SQL> @$ORACLE_HOME/javavm/install/initjvm.sql
2. But: there is no @$ORACLE_HOME/javavm/install/initjvm.sql scrript -> http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html -> Oracle 11g EX does not support java

Questions:

a) Does support Oracle 11g EX the impdp utility at all ?
b) How would it be possible to import the above mentioned dump from (A) into (B) ?

Thanks in advance,

Michel

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points