Oracle创建表空间及用户

/*第1步：创建临时表空间  */create temporary tablespace TS_CS_TEMPtempfile 'E:\app\Administrator\oradata\orcl\TS_CS_TEMP.dbf'size 64m autoextend on next 32m maxsize 20480m extent management local;  /*第2步：创建数据表空间  */create tablespace TS_CS_DATA logging datafile 'E:\app\Administrator\oradata\orcl\TS_CS_DATA01.dbf'size 64m autoextend on next 32m maxsize 20480m extent management local; /*第3步：新增数据表空间文件  */alter tablespace TS_CS_DATA add datafile 'E:\app\Administrator\oradata\orcl\TS_CS_DATA02.dbf' size 64m autoextend on next 32m maxsize 20480m; /*第4步：创建用户并指定表空间  */create user ceshi identified by ceshi default tablespace TS_CS_DATA temporary tablespace TS_CS_TEMP;  /*第5步：给用户授予权限  */grant connect,resource,dba to ceshi;grant alter system to ceshi;grant execute any procedure to ceshi;grant select any dictionary to ceshi;grant unlimited tablespace to ceshi;/*其他：允许已存在的数据文件自动增长  */alter database datafile 'E:\app\Administrator\oradata\orcl\APP03.DBF'autoextend on next 32m maxsize 20480m; /*其他：手工改变已存在数据文件的大小  */alter database datafile 'E:\app\Administrator\oradata\orcl\APP02.DBF'resize 64M;