ITPub博客

首页 > 数据库 > 数据库开发技术 > exp不能备份的问题

exp不能备份的问题

原创 数据库开发技术 作者:rainbowbridg 时间:2007-09-18 04:11:55 0 删除 编辑


With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and UTF8 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ORCL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ORCL
About to export ORCL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_METADATA", line 1511
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1864
ORA-06512: at "SYS.DBMS_METADATA", line 3707
ORA-06512: at "SYS.DBMS_METADATA", line 3689
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

先用sys执行下面脚本:
@?/rdbms/admin/catmeta.sql
然后执行:
select owner,object_name,object_type,status from dba_objects where status='invalid';
看看有没有无效的,如果没有则再倒出

如果有,则按步骤执行下面的
1. sql> conn / as sysdba
2. sql> startup migrate
3. sql> @/oraclehome/rdbms/admin/catpatch.sql
4. sql> select comp_id, comp_name, version, status from dba_registry;
这个时候应该没有问题了

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7916042/viewspace-969828/,如需转载,请注明出处,否则将追究法律责任。

下一篇: sqlldr的例子
请登录后发表评论 登录
全部评论
  • 博文量
    237
  • 访问量
    1587624