Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
759 views
in Technique[技术] by (71.8m points)

oracle修改用户表空间后查询指定表空间的表 还是需要显示查询

新建一用户,修改了默认表空间
alter user BENQ default tablespace WEBSITE;
select username, default_tablespace from dba_users where username='BENQ';
查询也已经修改了默认表空间

然后使用这个benq用户登陆进行操作

  1. select * from APP_TOKEN;
    如果不指定website表空间,查询不到
    创建新表也是在benq表空间下,没有在website下创建
  2. select * from WEBSITE.APP_TOKEN; 可以查询到

请问是哪里出了问题


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...