schema export error [message #71018] |
Tue, 27 August 2002 07:07 |
Abu 'Ubaidah
Messages: 6 Registered: June 2002
|
Junior Member |
|
|
i have the following error when doing a schema export.
the export goes ahead despite these errors but i can't import the resulting dump file.
i run oracle 8.1.6 on tru64 alpha v735
the error message:
About to export specified users ...
User to be exported: (RETURN to quit) > fccorp
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.s
chema_info_exp
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.sc
hema_info_exp
. exporting foreign function library names for user FCCORP
. exporting object type definitions for user FCCORP
About to export FCCORP's objects ...
. exporting database links
. exporting sequence numbers
|
|
|
Re: schema export error [message #71020 is a reply to message #71018] |
Tue, 27 August 2002 11:57 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
Try running $ORACLE_HOME/rdbms/admin/catexp.sql as SYS and then compile all invalid objects. Use this script to compile all your objects including SYS:
rem *********************************************************
rem * file: comp_all.sql
rem * purpose: compile all database stored objects
rem * to use: log in using the appropriate account then
rem * execute this script using the following syntax:
rem *
rem * SQL> @comp_all
rem *
rem * NOTE: You should not have to run this script more
rem * than once since it uses
rem * order_object_by_dependency table to compile
rem * objects in the proper order. Any
rem * compilation errors generated should be
rem * investigated.
rem *********************************************************
set heading off
set pagesize 0
set linesize 79
set verify off
set echo off
set feedback off
spool comp_tmp.sql
select
decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )
from
dba_objects
where
STATUS = 'INVALID' and OBJECT_TYPE in
( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW' )
order by OWNER, OBJECT_TYPE, OBJECT_NAME;
spool off
set echo on
@comp_tmp.sql
!rm comp_tmp.sql
|
|
|
Re: schema export error [message #71029 is a reply to message #71018] |
Wed, 28 August 2002 09:13 |
Abu 'Ubaidah
Messages: 6 Registered: June 2002
|
Junior Member |
|
|
Thanks Grant,
i have followed all your suggestions and run the script
as user SYS, the package SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp did not still compile,
i bounced my database and tried to export the schema again. i still got the same error.
any further suggestions?
how can i use the resulting dump file?
|
|
|
|