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