oracle 9.2.0.4升級到9.2.0.8時exp匯出時遇到的問題

exp system/abcdefg file=c:\test.dmp full=y.

. exporting table              WM$ADT_FUNC_TABLE          0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifie
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

升級 9.2.0.4到9.2.0.8只執行了相關補丁程式包:p4547809_92080_WINNT

沒執行catpatch.sql

sql>shutdown immediate;

sql>startup migrate;

sql> @ D:\oracle\ora92\rdbms\admin\catpatch.sql

COMP_NAME                           STATUS      VERSION
----------------------------------- ----------- --------------------
Oracle9i Catalog Views              VALID       9.2.0.8.0
Oracle9i Packages and Types         VALID       9.2.0.8.0
Oracle Workspace Manager            VALID       9.2.0.1.0

DOC>================================================================
DOC>   The above query lists the components in the database, along
DOC>   with their current patchset version and status.
DOC>================================================================
DOC>*/
DOC> END CATPATCH.SQL */

執行指令碼後 exp正常

C:\Documents and Settings\Paul Yi>exp system/abcdefg file=c:\test.dmp full=y

Export: Release 9.2.0.8.0 - Production on Tue May 27 16:59:00 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table            AQ$_INTERNET_AGENTS          0 rows exported
. . exporting table       AQ$_INTERNET_AGENT_PRIVS          0 rows exported
. . exporting table                    DEF$_AQCALL          0 rows exported
. . exporting table                   DEF$_AQERROR          0 rows exported
. . exporting table                  DEF$_CALLDEST          0 rows exported
. . exporting table               DEF$_DEFAULTDEST          0 rows exported
. . exporting table               DEF$_DESTINATION          1 rows exported
. . exporting table                     DEF$_ERROR          0 rows exported
. . exporting table                       DEF$_LOB          0 rows exported
. . exporting table                    DEF$_ORIGIN          0 rows exported
. . exporting table                DEF$_PROPAGATOR          0 rows exported
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exported
. . exporting table                  DEF$_TEMP$LOB          0 rows exported
. . exporting table                           HELP        918 rows exported
. . exporting table                  LOGMNRT_MDDL$
. . exporting table       LOGSTDBY$APPLY_MILESTONE          0 rows exported
. . exporting table        LOGSTDBY$APPLY_PROGRESS
. . exporting partition                             P0          0 rows exported
. . exporting table                LOGSTDBY$EVENTS          0 rows exported
. . exporting table            LOGSTDBY$PARAMETERS          0 rows exported
. . exporting table                 LOGSTDBY$PLSQL          0 rows exported
. . exporting table                   LOGSTDBY$SCN          0 rows exported
. . exporting table                  LOGSTDBY$SKIP          0 rows exported
. . exporting table      LOGSTDBY$SKIP_TRANSACTION          0 rows exported
. . exporting table        REPCAT$_AUDIT_ATTRIBUTE          2 rows exported
. . exporting table           REPCAT$_AUDIT_COLUMN          0 rows exported
. . exporting table           REPCAT$_COLUMN_GROUP          0 rows exported
. . exporting table               REPCAT$_CONFLICT          0 rows exported
. . exporting table                    REPCAT$_DDL          0 rows exported
. . exporting table             REPCAT$_EXCEPTIONS          0 rows exported
. . exporting table              REPCAT$_EXTENSION          0 rows exported
. . exporting table                REPCAT$_FLAVORS          0 rows exported
. . exporting table         REPCAT$_FLAVOR_OBJECTS          0 rows exported
. . exporting table              REPCAT$_GENERATED          0 rows exported
. . exporting table         REPCAT$_GROUPED_COLUMN          0 rows exported
. . exporting table      REPCAT$_INSTANTIATION_DDL          0 rows exported
. . exporting table            REPCAT$_KEY_COLUMNS          0 rows exported
. . exporting table           REPCAT$_OBJECT_PARMS          0 rows exported
. . exporting table           REPCAT$_OBJECT_TYPES         28 rows exported
. . exporting table       REPCAT$_PARAMETER_COLUMN          0 rows exported
. . exporting table               REPCAT$_PRIORITY          0 rows exported
. . exporting table         REPCAT$_PRIORITY_GROUP          0 rows exported
. . exporting table      REPCAT$_REFRESH_TEMPLATES          0 rows exported
. . exporting table                 REPCAT$_REPCAT          0 rows exported
. . exporting table              REPCAT$_REPCATLOG          0 rows exported
. . exporting table              REPCAT$_REPCOLUMN          0 rows exported
. . exporting table         REPCAT$_REPGROUP_PRIVS          0 rows exported
. . exporting table              REPCAT$_REPOBJECT          0 rows exported
. . exporting table                REPCAT$_REPPROP          0 rows exported
. . exporting table              REPCAT$_REPSCHEMA          0 rows exported
. . exporting table             REPCAT$_RESOLUTION          0 rows exported
. . exporting table      REPCAT$_RESOLUTION_METHOD         19 rows exported
. . exporting table  REPCAT$_RESOLUTION_STATISTICS          0 rows exported
. . exporting table    REPCAT$_RESOL_STATS_CONTROL          0 rows exported
. . exporting table          REPCAT$_RUNTIME_PARMS          0 rows exported
. . exporting table              REPCAT$_SITES_NEW          0 rows exported
. . exporting table           REPCAT$_SITE_OBJECTS          0 rows exported
. . exporting table              REPCAT$_SNAPGROUP          0 rows exported
. . exporting table       REPCAT$_TEMPLATE_OBJECTS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_PARMS          0 rows exported
. . exporting table     REPCAT$_TEMPLATE_REFGROUPS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_SITES          0 rows exported
. . exporting table        REPCAT$_TEMPLATE_STATUS          3 rows exported
. . exporting table       REPCAT$_TEMPLATE_TARGETS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_TYPES          2 rows exported
. . exporting table    REPCAT$_USER_AUTHORIZATIONS          0 rows exported
. . exporting table       REPCAT$_USER_PARM_VALUES          0 rows exported
. . exporting table        SQLPLUS_PRODUCT_PROFILE          0 rows exported
. about to export OUTLN's tables via Conventional Path ...
. . exporting table                            OL$          0 rows exported
. . exporting table                       OL$HINTS          0 rows exported
. . exporting table                       OL$NODES          0 rows exported
. about to export DBSNMP's tables via Conventional Path ...
. about to export WMSYS's tables via Conventional Path ...
. . exporting table              WM$ADT_FUNC_TABLE          0 rows exported
. . exporting table                    WM$ENV_VARS          1 rows exported
. . exporting table       WM$INSTEADOF_TRIGS_TABLE          0 rows exported
. . exporting table               WM$LOCKROWS_INFO          0 rows exported
. . exporting table             WM$MODIFIED_TABLES          0 rows exported
. . exporting table                    WM$MW_TABLE
. . exporting table        WM$NESTED_COLUMNS_TABLE          0 rows exported
. . exporting table               WM$NEXTVER_TABLE          0 rows exported
. . exporting table           WM$REPLICATION_TABLE          0 rows exported
. . exporting table    WM$RESOLVE_WORKSPACES_TABLE          0 rows exported
. . exporting table                   WM$RIC_TABLE          0 rows exported
. . exporting table          WM$RIC_TRIGGERS_TABLE          0 rows exported
. . exporting table         WM$TMP_DBA_CONSTRAINTS          0 rows exported
. . exporting table       WM$UDTRIG_DISPATCH_PROCS          0 rows exported
. . exporting table                 WM$UDTRIG_INFO          0 rows exported
. . exporting table            WM$VERSIONED_TABLES          0 rows exported
. . exporting table  WM$VERSIONED_TABLES_UNDO_CODE          0 rows exported
. . exporting table     WM$VERSION_HIERARCHY_TABLE          1 rows exported
. . exporting table               WM$VERSION_TABLE          0 rows exported
. . exporting table             WM$VT_ERRORS_TABLE          0 rows exported
. . exporting table            WM$WORKSPACES_TABLE          1 rows exported
. . exporting table        WM$WORKSPACE_PRIV_TABLE          8 rows exported
. . exporting table  WM$WORKSPACE_SAVEPOINTS_TABLE          0 rows exported
. about to export HR's tables via Conventional Path ...
. . exporting table                      COUNTRIES         25 rows exported
. . exporting table                    DEPARTMENTS         27 rows exported
. . exporting table                      EMPLOYEES        107 rows exported
. . exporting table                           JOBS         19 rows exported
. . exporting table                    JOB_HISTORY         10 rows exported
. . exporting table                      LOCATIONS         23 rows exported
. . exporting table                        REGIONS          4 rows exported
. about to export PAUL's tables via Conventional Path ...
. . exporting table                              A         18 rows exported
. . exporting table                              B          0 rows exported
. . exporting table                              C          0 rows exported
. . exporting table                     PLAN_TABLE          0 rows exported
. . exporting table                           TEST         25 rows exported
. . exporting table                    TEST_COLUMN         25 rows exported
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.

C:\Documents and Settings\Paul Yi>