表权限的错误及恢复

由于对public权限的不了解，在一个关于权限的试验中，我执行了如下语句

revoke select any table from public;引起了严重的后果——所有的package失效！

今天上午，做了一个很愚蠢的事情！
我在做权限的一些试验时，竟然在sys用户下，执行了如下sql：
SQL> revoke select any table from public;

撤销成功。

接下来，我切换用户：
SQL> conn
请输入用户名:  csjtdev/csjt@csorasvr
ERROR:
ORA-06553: PLS-213: STANDARD 包不可访问

访问程序包 DBMS_APPLICATION_INFO 时出错
已连接。
SQL> conn
请输入用户名:  csjtdev/csjt@csorasvr
ERROR:
ORA-06553: PLS-213: STANDARD 包不可访问

访问程序包 DBMS_APPLICATION_INFO 时出错
已连接。

连着登陆两次都出现如上错误。开始，并没有引起我的注意。于是，我用exit命令
退出了sqlplus，然后又重新登陆，还是报上述错误。但是，对表的操作并不受影响。
但这仍然没有引起我的注意。
恰好这时，同事打电话，告诉我所有的package都不可用，包括各个package下面的
存储过程。这才引起我的注意。我马上想到可能是当然执行的那句撤销权限的操作
对这产生了影响。
登陆plsql developer，编译这些包，报如下错误：
ORA-00604 error occurred at recursive SQL level
这个信息表明，在数据库执行内部SQL语句时，发生了错误。比如，要往表中插入一
行数据，但没有可扩展的空间。ORACLE于是去查寻，哪儿可以建立下一个扩展空间，
它有多大小，但没有成功。一般在发生ORA-00604错误时，还伴随着其它的错误，例
如：ORA-1547等。

基本上，我已经确定就是刚才那句撤销权限的操作导致的错误。现在就寻找解决的
办法吧！
我以sys帐户重新登陆，做如下查询：
SQL> select object_name from dba_objects where status = 'INVALID';

OBJECT_NAME
---------------------------------------------------------------------

ALL_REPGROUPED_COLUMN
ALL_REPPARAMETER_COLUMN
AURORA$SERVER$SHUTDOWN
AURORA$SERVER$STARTUP
CDC_CREATE_CTABLE_AFTER
CDC_DROP_CTABLE_BEFORE
CLIENT_IP_ADDRESS
CONNECTIONINTERFACE
CURSORMANAGERINTERFACE
DATABASEINTERFACE
DATABASE_NAME

OBJECT_NAME
---------------------------------------------------------------------

DATAPROVIDERINTERFACE
DATATYPEIDCONSTANTS
DBA_REPGROUPED_COLUMN
DBA_REPPARAMETER_COLUMN
DBJ_LONG_NAME
DBJ_SHORT_NAME
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMSOBJG_DP
DBMSZEXP_SYSPKGGRNT

OBJECT_NAME
---------------------------------------------------------------------

DBMS_ALERT
DBMS_APPCTX
DBMS_APPLICATION_INFO
DBMS_APPLY_ADM
DBMS_APPLY_ADM_INTERNAL
DBMS_APPLY_ERROR
DBMS_APPLY_PROCESS
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_SYS
DBMS_AQADM_SYSCALLS

OBJECT_NAME
---------------------------------------------------------------------

DBMS_AQELM
DBMS_AQIN
DBMS_AQJMS
DBMS_AQJMS_INTERNAL
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES

OBJECT_NAME
---------------------------------------------------------------------

DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_SYS_IMP_INTERNAL
DBMS_ASYNCRPC_PUSH
DBMS_AW
DBMS_AW_EXP
DBMS_BACKUP_RESTORE

OBJECT_NAME
---------------------------------------------------------------------

DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_PROCESS
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_CDC_UTILITY
DBMS_CRYPTO_TOOLKIT
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_CRYPTO_TOOLKIT_TYPES
DBMS_DDL
DBMS_DDL_INTERNAL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_DEBUG
DBMS_DEBUG_JDWP
DBMS_DEBUG_JDWP_CUSTOM
DBMS_DEFER
DBMS_DEFERGEN
DBMS_DEFERGEN_AUDIT
DBMS_DEFERGEN_INTERNAL
DBMS_DEFERGEN_LOB
DBMS_DEFERGEN_PRIORITY
DBMS_DEFERGEN_RESOLUTION
DBMS_DEFERGEN_UTIL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_DEFERGEN_WRAP
DBMS_DEFER_ENQ_UTL
DBMS_DEFER_IMPORT_INTERNAL
DBMS_DEFER_INTERNAL_QUERY
DBMS_DEFER_INTERNAL_SYS
DBMS_DEFER_QUERY
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_REPCAT
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_DESCRIBE

OBJECT_NAME
---------------------------------------------------------------------

DBMS_DISTRIBUTED_TRUST_ADMIN
DBMS_DRS
DBMS_EPGC
DBMS_EXPORT_EXTENSION
DBMS_EXTENDED_TTS_CHECKS
DBMS_FGA
DBMS_FLASHBACK
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_UTL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_IAS_CONFIGURE
DBMS_IAS_INST
DBMS_IAS_INST_UTL
DBMS_IAS_INST_UTL_EXP
DBMS_IAS_MT_INST
DBMS_IAS_MT_INST_INTERNAL
DBMS_IAS_QUERY
DBMS_IAS_SESSION
DBMS_IAS_TEMPLATE
DBMS_IAS_TEMPLATE_INTERNAL
DBMS_IAS_TEMPLATE_UTL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_IJOB
DBMS_INTERNAL_LOGSTDBY
DBMS_INTERNAL_REPCAT
DBMS_INTERNAL_TRIGGER
DBMS_IREFRESH
DBMS_ISNAPSHOT
DBMS_ITRIGGER_UTL
DBMS_JAVA
DBMS_JAVA_TEST
DBMS_JOB
DBMS_LCR

OBJECT_NAME
---------------------------------------------------------------------

DBMS_LOB
DBMS_LOCK
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_FFVTOLOGMNRT
DBMS_LOGMNR_INTERNAL
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_OCTOLOGMNRT
DBMS_LOGMNR_SESSION
DBMS_LOGREP_DEF_PROC
DBMS_LOGREP_DEF_PROC_UTL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGSTDBY
DBMS_MAINT_GEN
DBMS_METADATA
DBMS_METADATA_INT
DBMS_METADATA_UTIL
DBMS_OBFUSCATION_TOOLKIT
DBMS_OBFUSCATION_TOOLKIT_FFI

OBJECT_NAME
---------------------------------------------------------------------

DBMS_ODCI
DBMS_OFFLINE_INTERNAL
DBMS_OFFLINE_OG
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
DBMS_OFFLINE_UTL
DBMS_OUTPUT
DBMS_PCLXUTIL
DBMS_PICKLER
DBMS_PIPE
DBMS_PITR

OBJECT_NAME
---------------------------------------------------------------------

DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_PROPAGATION_ADM
DBMS_PRVTAQIM
DBMS_PRVTAQIP
DBMS_PRVTAQIS
DBMS_PRVTRMIE
DBMS_PSP
DBMS_PSWMG_IMPORT
DBMS_RANDOM
DBMS_RCVMAN

OBJECT_NAME
---------------------------------------------------------------------

DBMS_RECTIFIER_DIFF
DBMS_RECTIFIER_FRIENDS
DBMS_REDEFINITION
DBMS_REFRESH
DBMS_REFRESH_EXP_LWM
DBMS_REFRESH_EXP_SITES
DBMS_REGISTRY
DBMS_REGISTRY_SYS
DBMS_REPAIR
DBMS_REPCAT
DBMS_REPCAT_ADD_MASTER

OBJECT_NAME
---------------------------------------------------------------------

DBMS_REPCAT_ADMIN
DBMS_REPCAT_AUTH
DBMS_REPCAT_CACHE
DBMS_REPCAT_COMMON_UTL
DBMS_REPCAT_CONF
DBMS_REPCAT_DECL
DBMS_REPCAT_FLA
DBMS_REPCAT_FLA_MAS
DBMS_REPCAT_FLA_UTL
DBMS_REPCAT_INSTANTIATE
DBMS_REPCAT_INTERNAL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_REPCAT_INTERNAL_PACKAGE
DBMS_REPCAT_MAS
DBMS_REPCAT_MIG
DBMS_REPCAT_MIG_INTERNAL
DBMS_REPCAT_OBJ_UTL
DBMS_REPCAT_OUTPUT
DBMS_REPCAT_RGT
DBMS_REPCAT_RGT_ALT
DBMS_REPCAT_RGT_CHK
DBMS_REPCAT_RGT_CUST
DBMS_REPCAT_RGT_CUST

OBJECT_NAME
---------------------------------------------------------------------

DBMS_REPCAT_RGT_CUST2
DBMS_REPCAT_RGT_EXP
DBMS_REPCAT_RGT_UTL
DBMS_REPCAT_RPC
DBMS_REPCAT_RPC_UTL
DBMS_REPCAT_RQ
DBMS_REPCAT_SNA
DBMS_REPCAT_SNA_UTL
DBMS_REPCAT_SQL_UTL
DBMS_REPCAT_UNTRUSTED
DBMS_REPCAT_UTL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_REPCAT_UTL2
DBMS_REPCAT_UTL3
DBMS_REPCAT_UTL4
DBMS_REPCAT_UTL4
DBMS_REPCAT_VALIDATE
DBMS_REPUTIL
DBMS_REPUTIL2
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
DBMS_RESUMABLE
DBMS_RLS

OBJECT_NAME
---------------------------------------------------------------------

DBMS_RMGR_GROUP_EXPORT
DBMS_RMGR_PACT_EXPORT
DBMS_RMGR_PLAN_EXPORT
DBMS_RMIN
DBMS_ROWID
DBMS_RULE
DBMS_RULEADM_INTERNAL
DBMS_RULE_ADM
DBMS_RULE_COMPATIBLE_90
DBMS_RULE_EXIMP
DBMS_RULE_EXP_EC_INTERNAL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RL_INTERNAL
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULES
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTL
DBMS_RULE_IMP_OBJ
DBMS_SESSION
DBMS_SNAPSHOT
DBMS_SNAPSHOT_UTL
DBMS_SNAP_INTERNAL

OBJECT_NAME
---------------------------------------------------------------------

DBMS_SNAP_REPAPI
DBMS_SPACE
DBMS_SPACE_ADMIN
DBMS_SQL
DBMS_SQLJTYPE
DBMS_STANDARD
DBMS_STATS
DBMS_STATS_INTERNAL
DBMS_STORAGE_MAP
DBMS_STREAMS
DBMS_STREAMS_ADM

OBJECT_NAME
---------------------------------------------------------------------

DBMS_STREAMS_ADM_UTL
DBMS_SUMADV
DBMS_SUMADVISOR
DBMS_SUMMARY
DBMS_SUMREF_UTIL
DBMS_SUMVDM
DBMS_SYSTEM
DBMS_SYS_ERROR
DBMS_SYS_SQL
DBMS_TRACE
DBMS_TRANSACTION

OBJECT_NAME
---------------------------------------------------------------------

DBMS_TRANSACTION_INTERNAL_SYS
DBMS_TRANSFORM
DBMS_TRANSFORM_EXIMP
DBMS_TTS
DBMS_TYPES
DBMS_TYPE_UTILITY
DBMS_UTILITY
DBMS_XMLGEN
DBMS_XMLQUERY
DBMS_XMLSAVE
DBMS_XPLAN

OBJECT_NAME
---------------------------------------------------------------------

DBMS_XRWMV
DBMS_ZHELP
DBMS_ZHELP_IR
DEFINITIONMANAGERINTERFACE
DES_ENCRYPTED_PASSWORD
DIANA
DICTIONARY_OBJ_NAME
DICTIONARY_OBJ_NAME_LIST
DICTIONARY_OBJ_OWNER
DICTIONARY_OBJ_OWNER_LIST
DICTIONARY_OBJ_TYPE

OBJECT_NAME
---------------------------------------------------------------------

DIUTIL
FUNCTIONIDCONSTANTS
GETTVOID
GET_ERROR$
GRANTEE
HTF
HTP
INITJVMAUX
INSTANCE_NUM
INTERRUPTABLEINTERFACE
IS_ALTER_COLUMN

OBJECT_NAME
---------------------------------------------------------------------

IS_CREATING_NESTED_TABLE
IS_DROP_COLUMN
IS_SERVERERROR
JAVA_XA
LOGIN_USER
LOGMNR_CREATE_REPLACE_METADATA
LOGMNR_DICT_CACHE
LOGMNR_DPC
LOGMNR_GTLO3
LOGMNR_KRVRDA_TEST_APPLY
LOGMNR_KRVRDLUID3

OBJECT_NAME
---------------------------------------------------------------------

LOGMNR_KRVRDREPDICT3
LOGOFF_PROC
LOGON_PROC
LT
LTADM
LTAQ
LTDDL
LTDTRG
LTPRIV
LTRIC
LTUTIL

OBJECT_NAME
---------------------------------------------------------------------

LT_CTX_PKG
LT_EXPORT_PKG
LT_REPLN
MDMCLASSCONSTANTS
MDMOBJECTIDCONSTANTS
MDMPROPERTYIDCONSTANTS
METADATAPROVIDERINTERFACE
NO_VM_CREATE
NO_VM_CREATE_PROC
NO_VM_DROP
NO_VM_DROP_PROC

OBJECT_NAME
---------------------------------------------------------------------

NameFromLastDDL
ODCICOLINFODUMP
ODCICONST
ODCIENVDUMP
ODCIINDEXALTEROPTIONDUMP
ODCIINDEXCALLPROPERTYDUMP
ODCIINDEXINFODUMP
ODCIINDEXINFOFLAGSDUMP
ODCIPREDINFODUMP
ODCIQUERYINFODUMP
ODCISTATSOPTIONSDUMP

OBJECT_NAME
---------------------------------------------------------------------

OEMGETNEXTEXTEND
OLAPIBOOTSTRAP
OLAP_API_SESSION_INIT
OLAP_TABLE
OUTLN_EDIT_PKG
OUTLN_PKG
OWA
OWA_CACHE
OWA_COOKIE
OWA_CUSTOM
OWA_IMAGE

OBJECT_NAME
---------------------------------------------------------------------

OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
OWM_DDL_PKG
OWM_MIG_PKG
OWM_REPUTIL
PARAMETERIDCONSTANTS
PARTITION_POS
PBREAK

OBJECT_NAME
---------------------------------------------------------------------

PBRPH
PBSDE
PBUTL
PIDL
PLITBLM
PRIVILEGE_LIST
PRVT_EGUTL
PRVT_EPGC
PSTUB
PSTUBT
REVOKEE

OBJECT_NAME
---------------------------------------------------------------------

RMJVM
SERVERINTERFACE
SERVER_ERROR
SERVER_ERROR_DEPTH
SERVER_ERROR_MSG
SERVER_ERROR_NUM_PARAMS
SERVER_ERROR_PARAM
SPACE_ERROR_INFO
SQLJUTL
SQL_TXT
STANDARD

OBJECT_NAME
---------------------------------------------------------------------

STREAMS$_EVALUATION_CONTEXT
SUBPTXT
SUBPTXT2
SYSEVENT
SYS_IXMLAGG
SYS_LOGOFF
SYS_LOGON
SYS_STUB_FOR_PURITY_ANALYSIS
SYS_XMLAGG
UD_TRIGS
URIFACTORY

OBJECT_NAME
---------------------------------------------------------------------

USER_REPGROUPED_COLUMN
USER_REPPARAMETER_COLUMN
UTL_COLL
UTL_ENCODE
UTL_FILE
UTL_GDK
UTL_HTTP
UTL_INADDR
UTL_RAW
UTL_RECOMP
UTL_REF

OBJECT_NAME
---------------------------------------------------------------------

UTL_SMTP
UTL_TCP
UTL_URL
UTL_XML
WITH_GRANT_OPTION
WM_DDL_UTIL
WM_ERROR
WPG_DOCLOAD
WPIUTL
XMLATTRCOVER
XMLCHARDATACOVER

OBJECT_NAME
---------------------------------------------------------------------

XMLCONCAT
XMLDOCUMENTCOVER
XMLDOM
XMLDOMIMPLCOVER
XMLDTDCOVER
XMLELEMENTCOVER
XMLENTITYCOVER
XMLNNMCOVER
XMLNODECOVER
XMLNODELISTCOVER
XMLNOTATIONCOVER

OBJECT_NAME
---------------------------------------------------------------------

XMLPARSER
XMLPARSERCOVER
XMLPICOVER
XMLSEQUENCEFROMREFCURSOR
XMLSEQUENCEFROMREFCURSOR2
XMLSEQUENCEFROMXMLTYPE
XMLTEXTCOVER
XMLVALIDATE
XSLPROCESSOR
XSLPROCESSORCOVER
XSLSTYLESHEETCOVER

OBJECT_NAME
---------------------------------------------------------------------

_ALL_REPCOLUMN_GROUP
_ALL_REPCONFLICT
_ALL_REPGROUPED_COLUMN
_ALL_REPPARAMETER_COLUMN
_ALL_REPRESOLUTION
DBMS_REPCAT_AUTH
DEF$_PROPAGATOR_TRIG
ORA$_SYS_REP_AUTH
REPCATLOGTRIG
ORA$GRANT_SYS_SELECT
OWM_VALIDATE

OBJECT_NAME
---------------------------------------------------------------------

CARTRIDGE
IM
ORDANNOTATIONSEXCEPTIONS
ORDAUDIOEXCEPTIONS
ORDAUDIO_PKG
ORDDOCEXCEPTIONS
ORDIMAGECONSTANTS
ORDIMAGEEXCEPTIONS
ORDIMERRORCODES
ORDIMGEXTCODEC_PKG
ORDIMGSIG_PKG

OBJECT_NAME
---------------------------------------------------------------------

ORDIMG_PKG
ORDSOURCEEXCEPTIONS
ORDVIDEOEXCEPTIONS
ORDVIDEO_PKG
PVTCARTRIDGE
SCOREFUNC
SIMILARFUNC
ORDX_AIFC_AUDIO
ORDX_AIFF_AUDIO
ORDX_AUFF_AUDIO
ORDX_AVI_VIDEO

OBJECT_NAME
---------------------------------------------------------------------

ORDX_DEFAULT_AUDIO
ORDX_DEFAULT_DOC
ORDX_DEFAULT_VIDEO
ORDX_FILE_SOURCE
ORDX_HTTP_SOURCE
ORDX_MOOV_VIDEO
ORDX_MPEG_VIDEO
ORDX_MPGA_AUDIO
ORDX_RMFF_VIDEO
ORDX_WAVE_AUDIO
GEOCODER_HTTP

OBJECT_NAME
---------------------------------------------------------------------

HHAND
HHBYTELEN
HHCBIT
HHCELLBNDRY
HHCELLSIZE
HHCLDATE
HHCOLLAPSE
HHCOMMONCODE
HHCOMPARE
HHCOMPOSE
HHDECODE

OBJECT_NAME
---------------------------------------------------------------------

HHDISTANCE
HHENCODE
HHENCODE_BYLEVEL
HHGBIT
HHGETCID
HHGROUP
HHGTBIT
HHGTYPE
HHIDLPART
HHIDPART
HHINCRLEV

OBJECT_NAME
---------------------------------------------------------------------

HHJLDATE
HHLENGTH
HHLEVELS
HHMATCH
HHMAXCODE
HHNCOMPARE
HHNDIM
HHOR
HHORDER
HHPRECISION
HHSBIT

OBJECT_NAME
---------------------------------------------------------------------

HHSETCID
HHSTBIT
HHSTYPE
HHSUBDIVIDE
HHSUBSTR
HHXOR
MD
MD1
MD2
MDERR
MD_LRS

OBJECT_NAME
---------------------------------------------------------------------

PRVT_IDX
RTREE_IDX
SDO
SDO_3GL
SDO_ADMIN
SDO_AGGR_CENTROID
SDO_AGGR_CONVEXHULL
SDO_AGGR_LRS_CONCAT
SDO_AGGR_LRS_CONCAT_3D
SDO_AGGR_MBR
SDO_AGGR_UNION

OBJECT_NAME
---------------------------------------------------------------------

SDO_CATALOG
SDO_CONSTRUCT_DIM_ARRAY
SDO_CS
SDO_DROP_USER
SDO_GEOM
SDO_GEOM_TRIG_DEL1
SDO_GEOM_TRIG_INS1
SDO_GEOM_TRIG_UPD1
SDO_IDX
SDO_LRS
SDO_LRS_TRIG_DEL

OBJECT_NAME
---------------------------------------------------------------------

SDO_LRS_TRIG_INS
SDO_LRS_TRIG_UPD
SDO_META
SDO_MIGRATE
SDO_PRIDX
SDO_RELATE_MASK
SDO_RTREE_ADMIN
SDO_TUNE
SDO_UTIL
SDO_VERSION
TRANSFORM_MAP

OBJECT_NAME
---------------------------------------------------------------------

CTX_ADM
CTX_CATSEARCH
CTX_CLS
CTX_CONTAINS
CTX_DDL
CTX_DOC
CTX_MATCHES
CTX_OUTPUT
CTX_QUERY
CTX_REPORT
CTX_THES

OBJECT_NAME
---------------------------------------------------------------------

CTX_ULEXER
CTX_XPCONTAINS
DRIACC
DRIADM
DRICON
DRIDDL
DRIDDLC
DRIDDLR
DRIDDLX
DRIDISP
DRIDML

OBJECT_NAME
---------------------------------------------------------------------

DRIDOC
DRIEXP
DRIG
DRIIMP
DRILIST
DRILOAD
DRIOBJ
DRIOPT
DRIPARSE
DRIPIPE
DRIPREF

OBJECT_NAME
---------------------------------------------------------------------

DRIREC
DRIREP
DRIREPM
DRIREPS
DRIREPT
DRIREPZ
DRISCORE
DRITHS
DRITHSC
DRITHSD
DRITHSL

OBJECT_NAME
---------------------------------------------------------------------

DRITHSX
DRIUTL
DRIVAL
DRIXTAB
DRIXTABC
DRIXTABR
DRIXTABX
DRI_SUBLXV_LANG
DRI_VERSION
DRUE
DR_DEF

OBJECT_NAME
---------------------------------------------------------------------

PARALLELPOPUINDEX
SYNCRN
CONTENTSCHEMAIS
DBMS_REGXDB
DBMS_XDB
DBMS_XDBZ
DBMS_XDBZ0
DBMS_XDB_VERSION
DBMS_XMLDOM
DBMS_XMLPARSER
DBMS_XMLSCHEMA

OBJECT_NAME
---------------------------------------------------------------------

DBMS_XMLSCHEMA_INT
DBMS_XSLPROCESSOR
SERVLET_xdbpt
UNDER_PATH_FUNC
XDB$ACL_xdbpt
XDB$BOOTSTRAP
XDB$BOOTSTRAPRES
XDB$CONFIG_xdbpt
XDB$EXTNAME2INTNAME
XDB$INITXDBSCHEMA
XDB$PATCHUPDELETESCHEMA

OBJECT_NAME
---------------------------------------------------------------------

XDB$PATCHUPSCHEMA
XDBPI_FUNCIMPL
XDB_ANCOP
XDB_FUNCIMPL
XDB_PITRIG_PKG
XDB_PI_TRIG
XDB_PVTRIG_PKG
XDB_PV_TRIG
XDB_RVTRIG_PKG
XDB_RV_TRIG
ftp-log14_TAB_xdbpt

OBJECT_NAME
---------------------------------------------------------------------

http-log20_TAB_xdbpt
xdb-log9_TAB_xdbpt
WK$IS_ADMIN
WK$POST_OPTIMIZE_INDEX
WK$PRE_OPTIMIZE_INDEX
WK$UPD_INST
WK$UPD_INST_TRG1
WK$UPD_INST_TRG10
WK$UPD_INST_TRG11
WK$UPD_INST_TRG12
WK$UPD_INST_TRG13

OBJECT_NAME
---------------------------------------------------------------------

WK$UPD_INST_TRG14
WK$UPD_INST_TRG15
WK$UPD_INST_TRG16
WK$UPD_INST_TRG17
WK$UPD_INST_TRG18
WK$UPD_INST_TRG19
WK$UPD_INST_TRG2
WK$UPD_INST_TRG20
WK$UPD_INST_TRG21
WK$UPD_INST_TRG22
WK$UPD_INST_TRG23

OBJECT_NAME
---------------------------------------------------------------------

WK$UPD_INST_TRG3
WK$UPD_INST_TRG4
WK$UPD_INST_TRG5
WK$UPD_INST_TRG6
WK$UPD_INST_TRG7
WK$UPD_INST_TRG8
WK$UPD_INST_TRG9
WK$USER
WK$USERID
WKDS_ADM
WKIG

OBJECT_NAME
---------------------------------------------------------------------

WK_ADM
WK_CRW
WK_DDL
WK_DEF
WK_ERR
WK_JOB
WK_META
WK_PORTAL
WK_QRY
WK_QUERYAPI
WK_QUERYEXP

OBJECT_NAME
---------------------------------------------------------------------

WK_QUERY_ADM
WK_QUTIL
WK_SGP
WK_SNAPSHOT
WK_UTIL
DMT_ODM
DMT_OPUTIL
DMT_VERSION_UTIL
ODM_ABN_MODEL
ODM_ASSOCIATION_RULE_MODEL
ODM_ATTRIBUTE_IMPORTANCE_MODEL

OBJECT_NAME
---------------------------------------------------------------------

ODM_CLUSTERING_UTIL
ODM_KM_CLUSTERING_MODEL
ODM_MINING_MODEL_TRIGGER
ODM_MINING_TRANSFORMATION
ODM_MODEL_UTIL
ODM_NAIVE_BAYES_APPLY
ODM_NAIVE_BAYES_MODEL
ODM_OC_CLUSTERING_MODEL
ODM_START_MONITOR
ODM_STOP_MONITOR
ODM_SUPERVISED_MODEL

OBJECT_NAME
---------------------------------------------------------------------

OP_COMMON
CWM$CLASSIFY
CWM$EXCEPTIONS
CWM$EXPORT
CWM$OLAP$CUBE
CWM$OLAP$DIM$ATTRIBUTE
CWM$OLAP$DIMENSION
CWM$OLAP$HIERARCHY
CWM$OLAP$LEVEL
CWM$OLAP$LEVEL$ATTRIBUTE
CWM$OLAP$MEASURE

OBJECT_NAME
---------------------------------------------------------------------

CWM$UTIL
CWM$UTILITY
CWM2$AWLOGICALATTRUSEUPD
CWM2$AWLOGICALDIMUSEUPD
CWM2$AWLOGICALHIERUSEUPD
CWM2$AWLOGICALLEVELUSEUPD
CWM2$AWLOGICALLIMITSETUSEUPD
CWM2$AWLOGICALMEASUSEUPD
CWM2$AWPHYSICALOBJEXTUPD
CWM2$AWPHYSICALOBJPROPSUPD
CWM2$AWPHYSICALOBJRELOBJSUPD

OBJECT_NAME
---------------------------------------------------------------------

CWM2$AWPHYSICALOBJUPD
CWM2$AW_DIMENSIONMAPUPD
CWM2$AW_MEASUREMAPUPD
CWM2$CUBEDIMENSIONUSEUPD
CWM2$CUBEUPD
CWM2$DIMENSIONATTRIBUTEUPD
CWM2$DIMENSIONUPD
CWM2$DIMHIERLVLMAPUPD
CWM2$FACTDIMHIERMAPUPD
CWM2$FACTDIMHIERTPLSDTLUPD
CWM2$FACTKEYDIMHIERLVLMAPUPD

OBJECT_NAME
---------------------------------------------------------------------

CWM2$FACTKEYDIMHIERMAPUPD
CWM2$HIERARCHYUPD
CWM2$HIERCUSTOMSORTUPD
CWM2$HIERLEVELRELUPD
CWM2$LEVELATTRIBUTEMAPUPD
CWM2$LEVELATTRIBUTEUPD
CWM2$LEVELUPD
CWM2$MEASURETABLEMAPUPD
CWM2$MEASUREUPD
CWM2$SECURITY
CWM2$STOREDDIMLVLTPLSDTLUPD

OBJECT_NAME
---------------------------------------------------------------------

CWM2$STOREDDIMLVLTPLSUPD
CWM2_OLAP_AW_ACCESS
CWM2_OLAP_AW_MAP
CWM2_OLAP_AW_OBJECT
CWM2_OLAP_AW_UTILITY
CWM2_OLAP_CATALOG
CWM2_OLAP_CUBE
CWM2_OLAP_DIMENSION
CWM2_OLAP_DIMENSION_ATTRIBUTE
CWM2_OLAP_EXCEPTIONS
CWM2_OLAP_HIERARCHY

OBJECT_NAME
---------------------------------------------------------------------

CWM2_OLAP_INSTALLER
CWM2_OLAP_LEVEL
CWM2_OLAP_LEVEL_ATTRIBUTE
CWM2_OLAP_MANAGER
CWM2_OLAP_MEASURE
CWM2_OLAP_PC_TRANSFORM
CWM2_OLAP_TABLE_MAP
CWM2_OLAP_UTILITY
CWM2_OLAP_VALIDATE
DBMS_ODM
OLAPDIMVIEW

OBJECT_NAME
---------------------------------------------------------------------

OLAPFACTVIEW
DBTUNE_UTIL
GDB_AR_TR
GDB_AS_TR
GDB_CDOM_TR
GDB_DOM_TR
GDB_DV_TR
GDB_ECR_TR
GDB_EX_TR
GDB_FC_TR
GDB_FD_TR

OBJECT_NAME
---------------------------------------------------------------------

GDB_FI_TR
GDB_GN_TR
GDB_JCR_TR
GDB_NCLS_TR
GDB_NET_TR
GDB_NWA_TR
GDB_NW_TR
GDB_OC_TR
GDB_RCAT_TR
GDB_RC_TR
GDB_RDATASETS_TR

OBJECT_NAME
---------------------------------------------------------------------

GDB_RDOM_TR
GDB_RELEASE_TR
GDB_REPLICAS_TR
GDB_RR_TR
GDB_SDOM_TR
GDB_SR_TR
GDB_ST_TR
GDB_TB_TR
GDB_TC_TR
GDB_TR_TR
GDB_T_TR

OBJECT_NAME
---------------------------------------------------------------------

GDB_UM_TR
GDB_VR_TR
LAYERS_UTIL
LOCATOR_UTIL
LOCK_UTIL
LOGFILE_UTIL
METADATA_UTIL
PINFO_UTIL
RASTERCOLUMNS_UTIL
REGISTRY_UTIL
SDE_UTIL

OBJECT_NAME
---------------------------------------------------------------------

SDO_UTIL
SPCOL_DEL_CASCADE_1
SPCOL_DEL_CASCADE_10
SPCOL_DEL_CASCADE_11
SPCOL_DEL_CASCADE_12
SPCOL_DEL_CASCADE_13
SPCOL_DEL_CASCADE_14
SPCOL_DEL_CASCADE_15
SPCOL_DEL_CASCADE_16
SPCOL_DEL_CASCADE_17
SPCOL_DEL_CASCADE_18

OBJECT_NAME
---------------------------------------------------------------------

SPCOL_DEL_CASCADE_2
SPCOL_DEL_CASCADE_3
SPCOL_DEL_CASCADE_5
SPCOL_DEL_CASCADE_6
SPCOL_DEL_CASCADE_7
SPCOL_DEL_CASCADE_8
SPCOL_DEL_CASCADE_9
SREF_UTIL
SVR_CONFIG_UTIL
VERSION_USER_DDL
VERSION_UTIL

OBJECT_NAME
---------------------------------------------------------------------

XML_UTIL
DBMS_RCVCAT
DBMS_RCVMAN
ADD_JOB_HISTORY
SECURE_DML
SECURE_EMPLOYEES
UPDATE_JOB_HISTORY
INSERT_ORD_LINE
ORDERS_ITEMS_TRG
ORDERS_TRG
QS_APPLICATIONS

OBJECT_NAME
---------------------------------------------------------------------

AQ$_AQ$_MEM_MC_V
AQ$_QS_ORDERS_PR_MQTAB_V
QS_BOOKEDORDERS_QUE_R
AQ$_QS_WS_ORDERS_MQTAB_V
AQ$_QS_WS_ORDERS_PR_MQTAB_V
QS_WS_BACKORDERS_QUE_R
QS_WS_BOOKEDORDERS_QUE_R
QS_WS_SHIPPEDORDERS_QUE_R
AQ$_QS_ES_ORDERS_MQTAB_V
AQ$_QS_ES_ORDERS_PR_MQTAB_V
QS_ES_BACKORDERS_QUE_R

OBJECT_NAME
---------------------------------------------------------------------

QS_ES_BOOKEDORDERS_QUE_R
QS_ES_SHIPPEDORDERS_QUE_R
AQ$_QS_OS_ORDERS_MQTAB_V
AQ$_QS_OS_ORDERS_PR_MQTAB_V
QS_OS_BACKORDERS_QUE_R
QS_OS_BOOKEDORDERS_QUE_R
QS_OS_SHIPPEDORDERS_QUE_R
AQ$_QS_CBADM_ORDERS_MQTAB_V
QS_CBADM_BILLEDORDERS_Q_R
AQ$_QS_CS_ORDER_STATUS_QT_V
QS_CS_BACKORDERS_QUE_R

OBJECT_NAME
---------------------------------------------------------------------

QS_CS_BILLEDORDERS_QUE_R
QS_CS_BOOKEDORDERS_QUE_R
QS_CS_SHIPPEDORDERS_QUE_R
ARTERY_PACKAGE
BASETABLE
CAPTURE_PACKAGE
DEVICE_PACKAGE
DUTY_PACKAGE
EUL5_NAMED_ELEMS
FLUX_PACKAGE
MANAGE_PACKAGE

OBJECT_NAME
---------------------------------------------------------------------

MAP_PACKAGE
MYTASK_PACKAGE
OTT_PACKAGE
PROC_REPORT_DEVICECOUNTYEAR
PUBLIC_PACKAGE
REPFRAMEWORK_PACKAGE
REPORT122_PACKAGE
REPORT122_PACKAGE
REPORT_PACKAGE
ROAD_PACKAGE
TEMP_PACKAGE

OBJECT_NAME
---------------------------------------------------------------------

VIEW_FLUX_NOW
VMS_PACKAGE
V_FLUX_MONTHFLUX
V_FLUX_MONTHOCCUPY
V_FLUX_MONTHSPEED
V_FLUX_WEEKFLUX
V_FLUX_WEEKOCCUPY
V_FLUX_WEEKSPEED
V_FLUX_YEARFLUX
V_FLUX_YEAROCCUPY
V_FLUX_YEARSPEED

OBJECT_NAME
---------------------------------------------------------------------

WORKFLOW_PACKAGE
WORKPLAN_PACKAGE
DANWEI_DIANHUA_AFTRIG
DANWEI_ZHONGDUI_A
DIAODUDANWEI_DEL
DIAODU_DANWEI_AFTRIG
FCHECKFUNCTION
FCHECKMETHOD
FGETCHUJINGID
FGETDANWEIID
FGETDDHH24MISS

OBJECT_NAME
---------------------------------------------------------------------

FGETJIEJINGID
FGETPERZHIPARA
FGETROLECODE
FGETRULEDEF
FGETRULEISRULE
FGETRULEMAXCLS
FGETRULEMODE
FGETRULESYSLEN
FGETSYS_MENU_GROUPINFO_ID
FGETWEEKSTART
FGET_HUOJIN_MAX_BIANHAO

OBJECT_NAME
---------------------------------------------------------------------

GUI_YI_HUA_AFTRIG
PEI_ZHI_HEAD_AFTTRIG
SP_DELETEDATA
SP_DEL_BUILDINGTREE
SP_DEL_PEIZHITREE
SP_DEL_PHONE_TYPE
SP_DEL_WEIXIANLEIBIE
SP_GETPAIBAN
SP_GUIYIHUA
SP_IMPORT_DIANHUA
SP_JIEDAO

OBJECT_NAME
---------------------------------------------------------------------

SP_JISUAN
SP_JISUAN_ALL
SP_MOVE_ANQING
SP_QITA_JIEDAO
SP_TIMEDEL_BLACKLIST
SP_UPT_BUILDINGTREE
SP_UPT_PEIZHITREE
SP_UPT_PHONE_TYPE
SP_UPT_WEIXIANLEIBIE
SYS_FUNC_MENU_AFTER
SYS_FUNC_MENU_BEFORE

OBJECT_NAME
---------------------------------------------------------------------

SYS_GROUP_TREE_BEFORE
SYS_MEMU_DICT_AFTRIG
SYS_MENU_GROUPINFO_AFTRIG
SYS_ROLE_AFTER
SYS_ROLE_BEFORE
SYS_USER_ADD
SYS_USER_DEL_USER

已选择964行。

按照http://blog.itpub.net/post/468/5287提供的方法，我想依次执行如下sql语句：
alter package standard compile;
alter package dbms_standard compile;
%ORACLE_HOME%rdbms/admin/utlrp.sql
可是在执行第一句话时，就出现错误；
SQL> alter package standard compile;
alter package standard compile
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-06553: PLS-213: STANDARD 包不可访问

使用utlrp.sql执行来解决问题的方法看来是行不通了！于是，我按照另外一种方法，
执行catalog.sql和catproc.sql重建数据字典。
果然，执行了这个sql文件后，所有的包都编译通过！