Oracle创建表空间及用户

---创建表空间
create tablespace estate_db
datafile 'E:/estate_db.ora'
size 10M
autoextend on;

---创建临时表空间
create temporary  tablespace estate_temp_db
tempfile 'E:/estate_temp_db.ora'
size 5M
autoextend on;

---创建用户
create user estate
identified by estate
default tablespace estate_db
temporary tablespace estate_temp_db;

---为用户授权
grant connect , resource, dba to estate;