1.创建表空间DEFAULT_TBS,默认大小30G
create bigfile tablespace DEFAULT_TBS datafile ‘DEFAULT_TBS’ size 30G autoextend on next 500m maxsize 200G;
2.创建临时表空间apptemp
create temporary tablespace apptemp tempfile ‘apptemp’ size 4G;
3.创建demo用户,密码123456,指定用户表空间名 DEFAULT_TBS
create user demo identified by 123456 default tablespace DEFAULT_TBS temporary tablespace apptemp;
4.给用户赋权
grant connect,resource,dba,unlimited tablespace to demo;