Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

593460Mar 25 2013 — edited Apr 20 2013

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

This post has been answered by Richard Harrison . on Mar 26 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2013

Added on Mar 25 2013

#database-key-features, #export-import-sql-loader-external-tables

10 comments

5,398 views