昨天新建了一个数据库,应该是建成功了,可是执行下面的命令时,一直报table or view does not exist。
select * from dba_users; 查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
select * from all_users; 查看你能管理的所有用户!
select * from user_users; 查看当前用户信息 !
而且,用pl/sql Developer工具连接时,能登陆,点“Tables"时也提示table or view does not exist.
在原来的数据库上这些都正常。
select * from dba_users; 查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
select * from all_users; 查看你能管理的所有用户!
select * from user_users; 查看当前用户信息 !
而且,用pl/sql Developer工具连接时,能登陆,点“Tables"时也提示table or view does not exist.
在原来的数据库上这些都正常。
DATAFILE '/opt/ora9/oradata/myoracle/system01.dbf' SIZE 200m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
Undo TABLESPACE undotbs2 DATAFILE
'/opt/ora9/oradata/myoracle/undotbs02.dbf' size 200m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE
'/opt/ora9/oradata/myoracle/temp01.dbf' size 325m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
DEFAULT TABLESPACE users DATAFILE
'/opt/ora9/oradata/myoracle/usertbs01.dbf' size 100m
SYSAUX DATAFILE '/opt/ora9/oradata/myoracle/sysaux01.dbf' size 100M
LOGFILE
GROUP 1('/opt/ora9/oradata/myoracle/log11a.log','/opt/ora9/oradata/myoracle/log11b.log') SIZE 10m,
GROUP 2('/opt/ora9/oradata/myoracle/log21a.log','/opt/ora9/oradata/myoracle/log21b.log') SIZE 10m,
GROUP 3('/opt/ora9/oradata/myoracle/log31a.log','/opt/ora9/oradata/myoracle/log31b.log') SIZE 10m
CHARACTER SET ZHS16GBK;
上面是我新建数据库时的脚本
接下来:
create user myoracle1 identified by dddddd;
grant create session to myoracle1;
grant resource to myoracle1;
grant dba to myoracle1;
用同样的方式建立另一用户myoracle2,
然后用myoracle1登陆并建表:
create table Tab1(
Name varchar2(20) not null)
tablespace users;可是,用myoracle2登陆时select * from Tab1却提示:table or view does not exist,
这个和之前找不到user_users、all_users、dba_users应该是同一个问题...