10 Replies Latest reply on Apr 20, 2013 8:43 PM by 593460

    Does Oracle 11g Express Edition support the impdp utility ?


      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
      B) Target data base: Oracle Database 11g Express Edition Release

      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


      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,