Re: dilemma - need rescue

Ali88,

You could sign on as SYS and recreate your SYSAUTH$ table (and any others). But this will not populate the SYSAUTH$ table with the information you need. So you are left with 2 options:

1. Restore the database from a backup (you did back it up right?) or
2. Recreate the database from scratch.

HTH,
Brian

> ali88 wrote:
>
> 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
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================