Oracle Database Discussions

Hi,

I had a "crash" on my database and had to re-run the catalog.sql and catproc.sql scripts.
Now, I am able to connect to the database, browse through the tables, add tuples, etc.
But I am not able to create a new table, I get the following error:

SQL> create table test(i int);
create table test(i int)
*
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

Any ideas on what is going wrong?

To rebuild the catalog, I had followed the following steps:
- connect as sysdba user sys
alter system disable restricted session;
ALTER SYSTEM SET "_system_trig_enabled"=FALSE;
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
ALTER SYSTEM SET "_system_trig_enabled"=TRUE;
alter system disable restricted session;

Thanks,
Juliana