0 Replies Latest reply: Aug 31, 2011 8:56 PM by Etore Schiavini RSS

    datapump doesn't work - workaround

    Etore Schiavini
      Datapump doesn't work on 11g XE on Windows (didn't try on Linux), you get something like that:

      expdp bck/bck@xe
      Export: Release 11.2.0.2.0 - Beta on Wed Aug 31 22:30:25 2011
      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
      Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta
      ORA-39006: internal error
      ORA-39213: Metadata processing is not available

      It occurs because there are a entire directory missing:
      <oracle_home>\rdbms\xml\xsl

      If you copy that directory from another 11gR2 installation (even a Linux one) to your 11g XE and execute the following as sys:

      SQL> execute dbms_metadata_util.load_stylesheets

      you can make it work.

      Étore