Oracle DBA

1:创建表空间 wspspace,maxsize unlimited是大小不受限制

create tablespace tttspace
datafile 'D:/dev/oracle/tablespace/tttspace.dbf' size 300M  
autoextend on  
next 50M  
maxsize unlimited

 

2.创建用户

create user ttt identified by ttt default tablespace tttspace;

 

3.分配权限

grant connect,resource,create view to ttt;

 

grant create materialized view to ttt;

 

4.解锁用户

alter user hr account unlock;

 

5.更改密码

alter user hr identified by hr;

 

6.连接数据库

connection 用户名/密码 [as sysdba];

 

7. 查看表空间信息

SELECT * FROM DBA_TABLESPACES