Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dilemma - need rescue

dilemma - need rescue

From: ali88 <ali88_at_usa.com>
Date: Sun, 25 Feb 2001 03:17:27 -0600
Message-ID: <A44m6.136$Hx2.227133@nnrp2.sbc.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US