651   Oracle RedHat

[oracle@v0A-123-99-19 newdata]$ exp cwotest/cwotest file=/newdata/test_dba/cwotest_20141215.dmp log=/newdata/test_dba/cwotest_20141215.log owner=cwotest

Export: Release 10.2.0.5.0 – Production on Mon Dec 15 16:39:19 2014

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

Connected to: Oracle Database 10g Release 10.2.0.5.0 – 64bit Production
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: package body “LBACSYS.LBAC_UTL” has errors
ORA-06508: PL/SQL: could not find program unit being called: “LBACSYS.LBAC_UTL”
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling LBACSYS.LBAC_UTL.schema_info_exp

网上说是package编译出错了,重新编译,运行以下表编译包

SQL > @$ORACLE_HOME/rdbms/admin/catalog.sql
SQL > @$ORACLE_HOME/rdbms/admin/catproc.sql
SQL > @$ORACLE_HOME/rdbms/admin/utlrp.sql

重新备份没有报错了




Leave a Reply

Your email address will not be published. Required fields are marked *