| Export Failure [message #70267] |
Thu, 16 May 2002 07:00  |
Kenny
Messages: 12
Registered: July 1999
|
Junior Member |
|
|
Hello, I have a new database thats giving me some grief when I try to export.
Has anyone seen these errors before? I have run all the catalog/catproc/catexp type scripts and still run into these problems. Any ideas would be really helpful.Please send me an email directly: kenny@arkadium.com
Thanks!
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_SYS_SQL" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_SQL", line 9
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 20
ORA-06512: at line 1
|
|
|
|
| Re: Export Failure [message #70268 is a reply to message #70267] |
Thu, 16 May 2002 08:40  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
If you are sure catalog/catproc/catexp were run as SYS then perform this query to determine if you have invalid objects:
select owner, object_name, object_type, status from dba_objects where status='INVALID' order by owner;
If you have invalid SYS objects then compile them manually. If that doesn't fix the problem come back to this forum and we can try something else.
|
|
|
|
| Re: Export Failure [message #70270 is a reply to message #70267] |
Thu, 16 May 2002 10:14 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Yes they can be. You should not have any invalid objects. This was caused when you re-ran the scripts and it replaced what was in the DB with what is in cache. Run this script as sys. You may need to make a changes if your NT. If so change "!" with "host". This script compiles all invalid objects for all schema's. Run more than once.
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
