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
ES]lp0bBp0EXP-00056: ORACLE error 904 encounteredITPUB个人空间F4Qmy%[
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifieITPUB个人空间-O.{@`#ls[
. exporting synonyms
y
`J-vm0. exporting views
drQ+b(_0. exporting referential integrity constraintsITPUB个人空间W;e.f:?b7fl;S$kMO
. exporting stored procedures
Y)\^{jVm0. exporting operators
~&TR:n\0. exporting indextypesITPUB个人空间}/zXbq
. exporting bitmap, functional and extensible indexesITPUB个人空间)pw,?M6A"f4J
. exporting posttables actionsITPUB个人空间\N&[Cq/U:Z/j
. exporting triggers
VpA)T:e0. exporting materialized viewsITPUB个人空间\!iR2h4K X
. exporting snapshot logs
V |vz1Z;yfF:c0Fh0. exporting job queues
p4|EGt%N!aKS?0. exporting refresh groups and children
*}Nx;[ vA y%Js0j0. exporting dimensionsITPUB个人空间-K
\{r XpX
. exporting post-schema procedural objects and actionsITPUB个人空间{{8E!Ec9t z5U@
. exporting user history table
@z$j/J2S,[iB+p0. exporting default and system auditing optionsITPUB个人空间 ]9`%w8@ n\:N
. exporting statisticsITPUB个人空间,^ ^|
k"B~U+] T,D`s!l%t
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      VERSIONITPUB个人空间y/[W!~QNZI
----------------------------------- ----------- --------------------ITPUB个人空间h/[bfL H(G-w0M
Oracle9i Catalog Views              VALID       9.2.0.8.0
.`{&C4wi0Oracle9i Packages and Types         VALID       9.2.0.8.0
l9? Woo0Oracle Workspace Manager            VALID       9.2.0.1.0

DOC>================================================================ITPUB个人空间mZ'`UhX\1?0@-t
DOC>   The above query lists the components in the database, along
U)sg)zYt0DOC>   with their current patchset version and status.
K6?-`^UW0DOC>================================================================
eQDu!M z:Q0DOC>*/
W_`0nTFbJ0DOC> 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.

/B7C5X8NJ6p~ D1`'?(JX&J0Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
NqZ"oW-Db D7`F4A0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间$g:d x t4pby2D_{(~(w
JServer Release 9.2.0.8.0 - ProductionITPUB个人空间z:o];\(H'q.I'Mh
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export the entire database ...ITPUB个人空间}2p%n;eBk;H
. exporting tablespace definitionsITPUB个人空间P} CX-`@X8`_
. exporting profilesITPUB个人空间k]#Q|0q*Iz0y*A
. exporting user definitions
an!c"\-]$e&NB0. exporting rolesITPUB个人空间3^]#HoEV6B"p;w6@w"d
. exporting resource costsITPUB个人空间})G1h(@;oooq
. exporting rollback segment definitions
y7eFl1Q5Xw0. exporting database links
oCaS6Psy)b0. exporting sequence numbersITPUB个人空间 e+Jxo"d5MG
. exporting directory aliases
V/w7G$j*a7l$jK0Jf0. exporting context namespacesITPUB个人空间ATz#d)QW
. exporting foreign function library names
-p8L*m-cGI0. exporting PUBLIC type synonymsITPUB个人空间
S rUk xu9u,\5x0v?Y4U
. exporting private type synonyms
JU5e oEKW0@9s0. exporting object type definitions
C'xU&Pr^v%E)s0. exporting system procedural objects and actions
zZp t[x0. exporting pre-schema procedural objects and actionsITPUB个人空间+~{p;Py5zu k
. exporting cluster definitions
0?~dz)v0. about to export SYSTEM's tables via Conventional Path ...ITPUB个人空间I+q)\? J.Ai'X9L
. . exporting table            AQ$_INTERNET_AGENTS          0 rows exportedITPUB个人空间!~1Hyc/?#o
. . exporting table       AQ$_INTERNET_AGENT_PRIVS          0 rows exported
:w,b"sd{0. . exporting table                    DEF$_AQCALL          0 rows exported
y$t r$[z`'P0. . exporting table                   DEF$_AQERROR          0 rows exportedITPUB个人空间`2E1p*z:YMW
. . exporting table                  DEF$_CALLDEST          0 rows exportedITPUB个人空间-{\F`U(Q/T4I
. . exporting table               DEF$_DEFAULTDEST          0 rows exportedITPUB个人空间Q eH7SDNGEVP
. . exporting table               DEF$_DESTINATION          1 rows exported
z4v/@N+uk{0. . exporting table                     DEF$_ERROR          0 rows exported

p2SD2@Z x"B
@:M0. . exporting table                       DEF$_LOB          0 rows exported
Sx$\\)@Bg.?*p0. . exporting table                    DEF$_ORIGIN          0 rows exported

u\d4vd-q%x0. . exporting table                DEF$_PROPAGATOR          0 rows exportedITPUB个人空间w1?(Z-p;yn/G
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exportedITPUB个人空间)E T1WQ9h{J
. . exporting table                  DEF$_TEMP$LOB          0 rows exported
{a:]-~%jG3@0. . exporting table                           HELP        918 rows exported
[LXX$]_9jy0. . exporting table                  LOGMNRT_MDDL$ITPUB个人空间#Lf.tT;^ ^
. . exporting table       LOGSTDBY$APPLY_MILESTONE          0 rows exportedITPUB个人空间,Ad_cw(yu7w0cF3]M
. . exporting table        LOGSTDBY$APPLY_PROGRESSITPUB个人空间C#o(d"Bx9i
. . exporting partition                             P0          0 rows exportedITPUB个人空间|I&Prf!A
. . exporting table                LOGSTDBY$EVENTS          0 rows exported
4z"_L-nJ]0. . exporting table            LOGSTDBY$PARAMETERS          0 rows exported
0eboaR{/Q0. . exporting table                 LOGSTDBY$PLSQL          0 rows exported
7?(p'b\1LW0. . exporting table                   LOGSTDBY$SCN          0 rows exportedITPUB个人空间aqM&B!Ac4H-]
. . exporting table                  LOGSTDBY$SKIP          0 rows exportedITPUB个人空间9H4HB@(H
. . exporting table      LOGSTDBY$SKIP_TRANSACTION          0 rows exported
(v&P"mq)nTRL0. . exporting table        REPCAT$_AUDIT_ATTRIBUTE          2 rows exportedITPUB个人空间2X!Z(yI E&p2[l
. . exporting table           REPCAT$_AUDIT_COLUMN          0 rows exported
}#[ aqj](X5ow0. . exporting table           REPCAT$_COLUMN_GROUP          0 rows exportedITPUB个人空间 [0_^2Y,i:@ c4Yy
. . exporting table               REPCAT$_CONFLICT          0 rows exported
)kS|R'E@0. . exporting table                    REPCAT$_DDL          0 rows exportedITPUB个人空间"V,GuG+[2KHli
. . exporting table             REPCAT$_EXCEPTIONS          0 rows exported
^qY(X~!sR0. . exporting table              REPCAT$_EXTENSION          0 rows exported
K;U;? [)H.BJW n0. . exporting table                REPCAT$_FLAVORS          0 rows exportedITPUB个人空间7^*\l ~U"fe
. . exporting table         REPCAT$_FLAVOR_OBJECTS          0 rows exported
5oW+b| Z*j0. . exporting table              REPCAT$_GENERATED          0 rows exported
;o^O$b)I(q9We0. . exporting table         REPCAT$_GROUPED_COLUMN          0 rows exportedITPUB个人空间Y7C E5t#P'cf;D
F`
. . exporting table      REPCAT$_INSTANTIATION_DDL          0 rows exportedITPUB个人空间6{hrE*MO?f
j
. . exporting table            REPCAT$_KEY_COLUMNS          0 rows exported
t*C,V&FE(NZBG0. . exporting table           REPCAT$_OBJECT_PARMS          0 rows exported
)m;o,U w@Gl*M0. . exporting table           REPCAT$_OBJECT_TYPES         28 rows exportedITPUB个人空间4H#P#x:p+[ _/Mi*F
. . exporting table       REPCAT$_PARAMETER_COLUMN          0 rows exported
`ynltxw8Q0. . exporting table               REPCAT$_PRIORITY          0 rows exportedITPUB个人空间ET7^2r+o7P![3k
. . exporting table         REPCAT$_PRIORITY_GROUP          0 rows exportedITPUB个人空间S\6H7{
F}
. . exporting table      REPCAT$_REFRESH_TEMPLATES          0 rows exportedITPUB个人空间|g;b7OGJS
. . exporting table                 REPCAT$_REPCAT          0 rows exported
ls,H5E3O3W8L0. . exporting table              REPCAT$_REPCATLOG          0 rows exportedITPUB个人空间Y-z:mL3~\tL["t
. . exporting table              REPCAT$_REPCOLUMN          0 rows exported
~KF7w$\2k~0. . exporting table         REPCAT$_REPGROUP_PRIVS          0 rows exportedITPUB个人空间WL
QNo-MC
. . exporting table              REPCAT$_REPOBJECT          0 rows exportedITPUB个人空间D*z.dJ7m&U`*@
. . exporting table                REPCAT$_REPPROP          0 rows exportedITPUB个人空间v#F;Hhrz
. . exporting table              REPCAT$_REPSCHEMA          0 rows exported
yi&O4ZZJp hO0. . exporting table             REPCAT$_RESOLUTION          0 rows exported
0BH7K f:F^0. . exporting table      REPCAT$_RESOLUTION_METHOD         19 rows exportedITPUB个人空间A6j,C oJ,J1_ imK
. . exporting table  REPCAT$_RESOLUTION_STATISTICS          0 rows exported
}*e"LX)x5V~0. . exporting table    REPCAT$_RESOL_STATS_CONTROL          0 rows exported
7Iz;s8R ME0. . exporting table          REPCAT$_RUNTIME_PARMS          0 rows exportedITPUB个人空间;V,Qw0HbY
. . exporting table              REPCAT$_SITES_NEW          0 rows exported
BHa.O(i0. . exporting table           REPCAT$_SITE_OBJECTS          0 rows exported
&?;EJ4u~9L.yWp0. . exporting table              REPCAT$_SNAPGROUP          0 rows exported
+U7q*VYvC9D`0. . exporting table       REPCAT$_TEMPLATE_OBJECTS          0 rows exportedITPUB个人空间3IK5ZBxMl
. . exporting table         REPCAT$_TEMPLATE_PARMS          0 rows exported
K
a#~N-bz5J0. . exporting table     REPCAT$_TEMPLATE_REFGROUPS          0 rows exportedITPUB个人空间C#Y&iPHXEV u5W
. . exporting table         REPCAT$_TEMPLATE_SITES          0 rows exportedITPUB个人空间^|(]g)U
. . exporting table        REPCAT$_TEMPLATE_STATUS          3 rows exported
)uI,DD,A3^3W:N8@0. . exporting table       REPCAT$_TEMPLATE_TARGETS          0 rows exported
HC.naz:l0. . exporting table         REPCAT$_TEMPLATE_TYPES          2 rows exported
%w'ihs4C4s4n0. . exporting table    REPCAT$_USER_AUTHORIZATIONS          0 rows exported
3BdY fp|0. . exporting table       REPCAT$_USER_PARM_VALUES          0 rows exported
A{y-I$tH-F*L$|#L.`l0. . exporting table        SQLPLUS_PRODUCT_PROFILE          0 rows exported
+dS,gG&Hvg0. about to export OUTLN's tables via Conventional Path ...ITPUB个人空间:jUR q%@`/Q
. . exporting table                            OL$          0 rows exportedITPUB个人空间F0?,M1SZlWG1d
. . exporting table                       OL$HINTS          0 rows exportedITPUB个人空间#ID0t%H'Y5iW)d4|
. . exporting table                       OL$NODES          0 rows exported
6n/VJB5J*fV$k0. about to export DBSNMP's tables via Conventional Path ...
SY8vl/A x`,cK0. about to export WMSYS's tables via Conventional Path ...ITPUB个人空间 gv9H{ WA
. . exporting table              WM$ADT_FUNC_TABLE          0 rows exportedITPUB个人空间e-E[^%@
. . exporting table                    WM$ENV_VARS          1 rows exported
#xo:yE'd8_/X2K0. . exporting table       WM$INSTEADOF_TRIGS_TABLE          0 rows exported
Y/e9T*|r(Y0U0. . exporting table               WM$LOCKROWS_INFO          0 rows exportedITPUB个人空间.j)j%d&TY5A9^6gP
. . exporting table             WM$MODIFIED_TABLES          0 rows exportedITPUB个人空间2c g p9nA
. . exporting table                    WM$MW_TABLEITPUB个人空间zl Ld BtC(\
. . exporting table        WM$NESTED_COLUMNS_TABLE          0 rows exportedITPUB个人空间"? z Yl^
. . exporting table               WM$NEXTVER_TABLE          0 rows exported
9OBh#z!w~#x!Dq0. . exporting table           WM$REPLICATION_TABLE          0 rows exportedITPUB个人空间A:v;q`Q`E4j ]
. . exporting table    WM$RESOLVE_WORKSPACES_TABLE          0 rows exported
Q`R\F0. . exporting table                   WM$RIC_TABLE          0 rows exportedITPUB个人空间-Vxd"t;U?5E
. . exporting table          WM$RIC_TRIGGERS_TABLE          0 rows exportedITPUB个人空间F"?5GQI ?Ef^ Kh]
. . exporting table         WM$TMP_DBA_CONSTRAINTS          0 rows exportedITPUB个人空间7R(ma|P [ k6Q:i
. . exporting table       WM$UDTRIG_DISPATCH_PROCS          0 rows exported
*kbbT8`8eS4PQ0. . exporting table                 WM$UDTRIG_INFO          0 rows exported
"r;dHyAz?Z0. . exporting table            WM$VERSIONED_TABLES          0 rows exported
QN3mzQ}h5R0. . exporting table  WM$VERSIONED_TABLES_UNDO_CODE          0 rows exported
r,b]4w"P0. . exporting table     WM$VERSION_HIERARCHY_TABLE          1 rows exported
8yv&_ k(LI,Q J!H;C9bE0. . exporting table               WM$VERSION_TABLE          0 rows exported
_3b xq _2mH;Yc0. . exporting table             WM$VT_ERRORS_TABLE          0 rows exportedITPUB个人空间 D.ZB?;EFo1i
. . exporting table            WM$WORKSPACES_TABLE          1 rows exportedITPUB个人空间BR"q5f)DK)V|(B2S\9N N
. . exporting table        WM$WORKSPACE_PRIV_TABLE          8 rows exportedITPUB个人空间[\:~6]}'??I
. . exporting table  WM$WORKSPACE_SAVEPOINTS_TABLE          0 rows exportedITPUB个人空间p*V}c!I:c5I r
. about to export HR's tables via Conventional Path ...
I.NpT`
c]5rZ0. . exporting table                      COUNTRIES         25 rows exported
'P7X&}'uKk.[hu0. . exporting table                    DEPARTMENTS         27 rows exported
TBs P(RV_ID0. . exporting table                      EMPLOYEES        107 rows exportedITPUB个人空间WX}9opw;R7\
. . exporting table                           JOBS         19 rows exportedITPUB个人空间(z}5a@.Q_w4qQ
. . exporting table                    JOB_HISTORY         10 rows exportedITPUB个人空间P%gE@n i~2A
. . exporting table                      LOCATIONS         23 rows exportedITPUB个人空间w gnZL
c8T
. . exporting table                        REGIONS          4 rows exported
.])P:hK|X0. about to export PAUL's tables via Conventional Path ...
F)f|*p+A&U
R1J)c%}I0. . exporting table                              A         18 rows exportedITPUB个人空间 W_T\;l'n0k
. . exporting table                              B          0 rows exported
} F/?MC0. . exporting table                              C          0 rows exportedITPUB个人空间R/q]K#v,r$|b ]"}
. . exporting table                     PLAN_TABLE          0 rows exportedITPUB个人空间+c8H-a }+d y
. . exporting table                           TEST         25 rows exported
An1fe8O)[
K{0. . exporting table                    TEST_COLUMN         25 rows exported
T+PN%c9jO0. exporting synonymsITPUB个人空间z3j[lf5kG
. exporting viewsITPUB个人空间VS1mC/DqB.h
. exporting referential integrity constraints
%b'e
vh)IXWB
\|0. exporting stored procedures
"I+v4H+X6Z.J0. exporting operatorsITPUB个人空间0u#o6uExz*`PS|A
. exporting indextypes
fS7[/T1XqZoO0. exporting bitmap, functional and extensible indexes
U7d0A a7{ ?#j0. exporting posttables actions
\D)D gd1M(s.e0. exporting triggers
6_ U%SN*m xC0. exporting materialized views
2~N1gP
o'W8UV0. exporting snapshot logs
WWp^n5~"F c-\9]0. exporting job queues
K']!{;]{~*m*?0. exporting refresh groups and childrenITPUB个人空间;AI4fBSW`
. exporting dimensions
\,HP:wi0. exporting post-schema procedural objects and actionsITPUB个人空间#xX tT2Eq*\
. exporting user history tableITPUB个人空间q*}+}x)RD4}
. exporting default and system auditing optionsITPUB个人空间*R dSX4gAn kU9a
. exporting statistics
{|?2~L8S T$H\ W8z0Export terminated successfully without warnings.

C:\Documents and Settings\Paul Yi>