errors during recompilation/revalidation of SYS.CDC_CREATE_CTABLE_BEFORE

From: Cris Carampa <cris119_at_operamail.com>
Date: Thu, 31 Jul 2003 14:15:22 +0200
Message-ID: <bgb19e$ss3$1@panco.nettuno.it>

I created a new database, then I ran the catalog.sql script. By mistake I ran it under SYSTEM user instead of SYS. When I acknowledged this, I interrupted the script, connected as SYS and tried to run the script again. Now it failes to create package STANDARD with following errors:

SQL> @standard
create or replace
*

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.CDC_CREATE_CTABLE_BEFORE

ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

create or replace
*

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.CDC_CREATE_CTABLE_BEFORE

ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

Grant succeeded.

Any ideas?

-- 
Cris Carampa (spamto:cris119_at_operamail.com)
Berlusconi's corollary to Godwin's Law: "As a parliament discussion
grows longer, the probability of a comparison involving Nazis or Hitler
approaches one."

Received on Thu Jul 31 2003 - 07:15:22 CDT