oracle 9.2.0.4升级到9.2.0.8时exp导出时遇到的问题

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:396

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>

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】