catalog/catproc as system

From: Vince Bono <vjb_at_netlabs.net>
Date: Mon, 15 Aug 2005 16:35:11 -0400
Message-ID: <x-udnZ2dnZ1SDoTOnZ2dnaZhnd6dnZ2dRVn-yp2dnZ0@netlabs.net>

I was trying to fix an export issue and mistakenly ran @catalog.sql
@catproc.sql
as SYSTEM instead of SYS
(I've since re-run them as SYS several times) The database appears to be working fine, However I'm still not able to EXPORT data.

Any insight ?

-Vince

exp system/passwd file=output.exp OWNER=icosmcus Export: Release 10.1.0.2.0 - Production on Mon Aug 15 16:32:52 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICOSMCUS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICOSMCUS
About to export ICOSMCUS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions

EXP-00056: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYSTEM.DBMS_METADATA" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Received on Mon Aug 15 2005 - 15:35:11 CDT