楼上的,先谢谢但我 select * from v$system_parameter 时候,提示如下,是否我的权限不够?ORA-00942: table or view does not exist select * from v$system_parameter
info. of database: SQL> select * from v$database; info. of instance: SQL> select * from v$instance;
同意楼上的,不过你得有这个权限才行!Thanks Hima
SQL> select * from v$database 2 ; DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHEC ---------- --------- --------- ----------------- --------- ----------------------- --------- ------------ ---- 1196732985 TIGER 05-JUN-06 318842 05-JUN-06 1 09-MAR-04 ARCHIVELOGSQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION --------------- ---------------- ---------------------------------------------------------------- ------------ 1 tiger CTUWINXPDSK128 10.1.0.2.0
谢谢各位.如果我有DBA的权限 select * from v$system_parameter select * from v$instance select * from v$database但如果没有DBA的权限,以上的提示均为 ORA-00942: table or view does not existinsufficient privilege 还有其他办法吗,谢谢
select * from v$system_parameter
info. of instance: SQL> select * from v$instance;
Hima
SQL> select * from v$database
2 ; DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHEC
---------- --------- --------- ----------------- --------- ----------------------- --------- ------------ ----
1196732985 TIGER 05-JUN-06 318842 05-JUN-06 1 09-MAR-04 ARCHIVELOGSQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION
--------------- ---------------- ---------------------------------------------------------------- ------------
1 tiger CTUWINXPDSK128 10.1.0.2.0
select * from v$system_parameter
select * from v$instance
select * from v$database但如果没有DBA的权限,以上的提示均为
ORA-00942: table or view does not existinsufficient privilege
还有其他办法吗,谢谢