SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 20 21:01:11 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: sys 输入口令: ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER 请输入用户名: system 输入口令:连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select name,*from v$database 2 select * from v$table 3 select * from v$table 4 select * from v$table 5 SQL> SQL>这个样子?不行啊
SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 20 23:07:32 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: system 输入口令:连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select name,* from from v$database; select name,* from from v$database * 第 1 行出现错误: ORA-00936: 缺失表达式 SQL> select * from v$table; select * from v$table * 第 1 行出现错误: ORA-00942: 表或视图不存在SQL> select name,* from name v$database; select name,* from name v$database * 第 1 行出现错误: ORA-00936: 缺失表达式 SQL> select *from v$table; select *from v$table * 第 1 行出现错误: ORA-00942: 表或视图不存在 SQL>
select name,* from from v$database; select name,* from from v$database * 第 1 行出现错误: ORA-00936: 缺失表达式 改成: SELECT * FROM V$instance; --数据库实例 SELECT * FROM v$database; --查看数据库 SELECT * FROM dba_tables a WHERE a.owner = UPPER('scott'); --查看scott用户所拥有的表 SELECT * FROM dba_tablespaces;--查看数据库表空间
改为:select * from v$database; 或者用 楼上的方法:select * from user_table; select * from dba_table;
select * from v$table
顶看表 见 user_table,all_table,dba_table或者pl/sql develop看
SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 20 21:01:11 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: sys
输入口令:
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
请输入用户名: system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select name,*from v$database
2 select * from v$table
3 select * from v$table
4 select * from v$table
5
SQL>
SQL>这个样子?不行啊
SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 20 23:07:32 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select name,* from from v$database;
select name,* from from v$database
*
第 1 行出现错误:
ORA-00936: 缺失表达式
SQL> select * from v$table;
select * from v$table
*
第 1 行出现错误:
ORA-00942: 表或视图不存在SQL> select name,* from name v$database;
select name,* from name v$database
*
第 1 行出现错误:
ORA-00936: 缺失表达式
SQL> select *from v$table;
select *from v$table
*
第 1 行出现错误:
ORA-00942: 表或视图不存在
SQL>
select name,* from from v$database
*
第 1 行出现错误:
ORA-00936: 缺失表达式
改成:
SELECT * FROM V$instance; --数据库实例
SELECT * FROM v$database; --查看数据库
SELECT * FROM dba_tables a WHERE a.owner = UPPER('scott'); --查看scott用户所拥有的表
SELECT * FROM dba_tablespaces;--查看数据库表空间
或者用 楼上的方法:select * from user_table;
select * from dba_table;
select * from user_tables; --查看由当前用户创建的所有表的表名
select * from dba_tables; --查看DBA可以访问到的所有表的表名