exp不能备份的问题
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;
这个时候应该没有问题了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-969828/ ，如需转载，请注明出处，否则将追究法律责任。
