EXP操作时,
数据库报错
Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in ZHS16GBK character set and UTF8 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object
SYS.DBMS_STANDARD
EXP-00083: The previous problem occurred when calling
SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp
EXP-00008: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object
SYS.DBMS_STANDARD
EXP-00083: The previous problem occurred when calling
SYS.DBMS_REFRESH_EXP_LWM.schema_info_exp
EXP-00008: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object
SYS.DBMS_STANDARD
EXP-00083: The previous problem occurred when calling
SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
EXP-00008: ORACLE error 4020 encountered
问了一下DBA支持人员,进行如下操作后正常:
SQL> startup migrate
SQL> SPOOL patch.log
SQL> @$ORACLE_HOME/rdbms/admin/catpatch.sql
(如果升级为10.2.04,则是catupgrd.sql脚本)
--打完patch后重建数据字典视图脚本catpatch.sql
SQL> SPOOL OFF
SQL> shutdown immediate
SQL> startup
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> shutdown immediate
SQL>startup
阅读(676) | 评论(0) | 转发(0) |