Re: ORA-04045 : catalog.sql and catproc.sql damaged my db
Date: Tue, 25 Mar 2003 11:02:05 +0000
Message-ID: <2680623.1048590125_at_dbforums.com>
actually this is related to several bugs on several releases... from
8.0.4 to 8.1.6
here is a partial list. 1314167, 1102966, 875427, 759735, 753384,
647800 and Bug 1314167
there is a work around posted on metalink.
identify invalid system objects:
select 'alter type sys.'|| object_name || ' compile;'
from all_objects
where status = 'INVALID'
and owner = 'SYS'
and object_type = 'TYPE';
you have to perform a drop operation on the queue_table even though you did not create any queue tables explicitly. Two queue tables are created by catdefrt.sql when a database is initialized.
select * from dba_queue_tables;
SYSTEM.DEF$_AQCALL execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL');
ORA-24012 "cannot drop QUEUE_TABLE, some queues in %s have not been dropped", you must use the force option in the procedure:
execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL', TRUE);
-AND-
execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQERROR', TRUE);
This is a Bug in which two queue tables are created by
catdefrt.sql when the
database is initialized regardless of whether the Replication option is
installed.
--
Posted via http://dbforums.com
Received on Tue Mar 25 2003 - 12:02:05 CET