Re: how to reconstruct v$paramter???

zhangguoping_at_boco.com.cn wrote:

> when i use "show parameter opt"
>
> it returns
>
> "ORA-00942: table or view does not exit"
>
> how can i rebuild v$paramter

How do you know it is gone versus the more likely possibility that

1. You don't have sufficient privileges
2. You lost the synonym (v$parameter is a synonym, not an object).

If you really have dropped the object someone should take away your permission to log on as SYS and then rerun catalog.sql.

Daniel Morgan Received on Wed Mar 26 2003 - 23:36:48 CST