Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> dilemma - need rescue
Hi all,
I noticed that some static dictionary tables and their indexes are
fragmented after a while in my Oracle8i database where a typical
installation was choose. I was trying to defragment a non-production
Oracle8i(8.1.7) database. Unfortunately, the dictionary tables SYSAUTH$
and SYSTEM PRIVILEGE MAP were dropped among other objects during the
process. After that, any sql statement and import utility will generate
an error, ORA-00604: error occurred at recursive SQL level 1, followed
by ORA-00942: table or view does not exist. All of a sudden, users and
system accounts can't even login due to lack of create session
privilege. I try to recreate these tables from the sql.bsq but couldn't
fix the problem. I believe that's because all the system privileges and
authentications settings were lost.
Is there any solution to fix this without having to recreate the
instance? Any suggestion is appreciated.
Ali88
--Received on Sun Feb 25 2001 - 03:17:27 CST