(1)无法用所有默认用户登录SQL Plus :
解决方案:运行->cmd-> 键入命令:sqlplus / as sysdba
(2)查询数据库中所有用户:select username from dba_users;
(3)查询数据库中所有表空间:select * from sys.dba_tablespaces;
(4)创建用户:
create user dcuser default tablespace users
tamporary tablespace temp;
alter user dcuser indentified by dvtecc;
(5)遇到如下错误:
5.1 ORA-28000:账户已被锁定
5.2 ORA-01045
SP2-0640:为连接
解决方案:
授权:Grant resource,conect to dcuser;
Grant create session to dcuser;