Cannot create or drop any oracle objects

Question

I'm trying to update an oracle database so that it's schema matches a second database exactly. In doing so I've hosed something. I can't create or drop any object.

create or replace procedure eag.test
as
begin
    null;
end;

Error:

ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I get the same error for any create or drop I try to do. Any ideas?

EDIT: running Oracle 10.2.0.4

Answer 1

You have a corrupt data dictionary.

If you can build a new database and start you sync process over. This time not using sysdba. Only sysdba has privileges to be destructive to the data dictionary.

If you need the data but can start over you may still be able to export the data using exp or expdp.

If you can't start over with a new database. Open a SAR with Oracle support. Even if someone else might be able to walk you through this they are the only ones who can bring your database back to an Oracle Supported state.