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;