gtlions

207 积分	1 好友	4 主题

发消息

exp错误

1^#

发表于 2011-11-14 14:31:09 | 查看: 6980| 回复: 4

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL>

[oracle@localhost ~]$ exp system/test owner=store1

Export: Release 10.2.0.4.0 - Production on Mon Nov 14 14:29:49 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: view "SYSTEM.SESSION_ROLES" has errors
ORA-06512: at "SYS.DBMS_RULE_EXP_UTLI", line 13
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 146
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
. exporting foreign function library names for user STORE1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user STORE1
About to export STORE1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export STORE1's tables via Conventional Path ...
. . exporting table                         BONUS       0 rows exported
. . exporting table                         DEPT       9 rows exported
. . exporting table                         DUMMY       1 rows exported
. . exporting table                         EMP       28 rows exported
. . exporting table                      SALGRADE       5 rows exported
. . exporting table                      TABLE1    100000 rows exported
. . exporting table                         TEST       1 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: view "SYSTEM.SESSION_ROLES" has errors
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 92
ORA-06512: at "SYS.DBMS_SCHED_EXPORT_CALLOUTS", line 38
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_SCHED_EXPORT_CALLOUTS.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: view "SYSTEM.SESSION_ROLES" has errors
ORA-06512: at "EXFSYS.DBMS_EXPFIL_DEPASEXP", line 52
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: view "SYSTEM.DBA_AWS" has errors
ORA-06512: at "SYS.DBMS_AW_EXP", line 20
ORA-06512: at "SYS.DBMS_AW_EXP", line 467
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: view "SYSTEM.SESSION_ROLES" has errors
ORA-06512: at "SYS.DBMS_RULE_EXP_UTLI", line 13
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 146
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.
[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 14 14:29:58 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

分享0