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>
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-312643/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Windows 系統安裝Oracle升級到9.2.0.8 後，exp問題WindowsOracle
- oracle 9.2.0.8 exp-00024 問題Oracle
- exp匯出檔案時 字符集設定問題
- php部署到nginx時遇到的問題PHPNginx
- exp 匯出時帶時間格式的檔案設定
- oracle11g 空表不能exp匯出的問題Oracle
- 在釋出war包時遇到的問題
- oracle 9.2.0.1 升級到oracle 9.2.0.8方法Oracle
- Export/Import匯入匯出時的字符集問題ExportImport
- 解決Oracle 11g空表不能exp匯出的問題Oracle
- 使用 redisson 時遇到的問題Redis
- python 寫 po 模式時遇到的迴圈匯入問題Python模式
- Oracle RAC 10.2.0.5升級到11.2.0.4遇到的問題Oracle
- Oracle 11G用EXP時，空表不能匯出解決方法Oracle
- Oracle匯入(imp )與匯出(exp )Oracle
- 【ORACLE 匯入匯出】exp 錯誤Oracle
- ORACLE匯入匯出命令exp/impOracle
- Nuxt升級2.0.0時出現的問題UX
- Oracle exp/imp匯出匯入工具的使用Oracle
- oracle資料的匯入匯出imp/expOracle
- vue 克隆物件時遇到的問題Vue物件
- AIX上oracle匯出備份EXP-00056: 遇到 ORACLE 錯誤 600AIOracle
- 用dbua實現oracle 9.2.0.8到10.2.0.1的升級Oracle
- IBM aix下oracle 9.2.0.5 rac 升級到oracle 9.2.0.8IBMAIOracle
- oracle資料匯出匯入（exp/imp）Oracle
- Oracle 遠端匯出匯入 imp/expOracle
- exp匯出報錯EXP-00106問題處理
- Oracle Expdp匯出時定義任務名後終止退出的問題Oracle
- 如何根據exp匯出檔案確定client端匯出時的字符集client
- mysql 5.5.9 匯出匯入到5.1.41 的問題MySql
- Oracle資料匯入匯出imp/exp命令Oracle
- 在linux 安裝oracle10g時遇到的問題LinuxOracle
- 資料升級到5.1所遇到的問題
- oracle的時區問題Oracle
- 11g exp匯出時部分表導不出來的解決
- Oracle exp只匯出部分資料Oracle
- Oracle Database 11.1.0.7 for Windows升級到11.2.0.3.4 for Linux遇到的問題OracleDatabaseWindowsLinux
- Oracle日常問題-臨時表過多導致exp速度慢Oracle