oracle创建表空间

------第1步：创建临时表空间create temporary tablespace myproject_temptempfile 'E:\ORACLE\ORADATA\ORCL\MYPROJECT_TEMP.DBF'size 10mautoextend onnext 10m maxsize 2048mextent management local;/*第2步：创建数据表空间  */create tablespace myproject_dataloggingdatafile 'E:\ORACLE\ORADATA\ORCL\MYPROJECT_DATA.DBF'size 10mautoextend onnext 10m maxsize 2048mextent management local;/*第3步：创建用户并指定表空间  */create user testuser1 identified by testuser1  default tablespace MYPROJECT_DATA  temporary tablespace MYPROJECT_TEMP;/*第4步：给用户授予权限  */grant connect,resource,dba to testuser1;