Removing xmldb and breaking datapump



We recently removed XDB from some of out systems as excessive use of truncate in the application seemed to be calling an internal xdb function and fragmenting the shared pool causing ORA-04031 errors.

XMLDB was not used by the application so we could safely remove it using the standard metalink notes on that subject.

It removed fine and everything was valid but when we tried to use exp we got the following error thrown:

Export: Release - Production on Mon Nov 11 12:54:11 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning option
ORA-39006: internal error
ORA-39213: Metadata processing is not available

To fix this we needed to ‘re-initialize’ the datapump internals – to do this we ran:


Then everything was fine again


Post a Comment