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
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论