CentOS7安装完Oracle11gR2+创建完成用户与表后,无法执行sql语句,也sys查询不到任何表,上网搜不到答案,求助

$ sqlplus /nolog
SQL> conn sys/oracle as sysdba
SQL> select table_name from dba_tables;
select table_name from dba_tables

                   *

ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select username,default_tablespace from dba_users;
select username,default_tablespace from dba_users

                                          *

ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from session_privs;
select * from session_privs

          *

ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select user from dual;

USER

SYS
SQL> select * from user_role_privs;
select * from user_role_privs

          *

ERROR at line 1:
ORA-00942: table or view does not exist

阅读 2.5k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题