Removing xmldb and breaking datapump

 

pumpkin-201103_640

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 11.2.0.3.0 - 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 11.2.0.3.0 - 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:


@?/rdbms/admin/catmeta
@?/rdbms/admin/catmet2



Then everything was fine again

Comments