-
第1步：创建临时表空间
create temporary tablespace pgenius_temptempfile '\data\oracle\oracledata\pgenius_temp.dbf'size 50m autoextend on next 50m maxsize 20480mextent management local;
删除临时表空间：
drop tablespace pgenius_temp including contents and datafiles;
-
第2步：创建数据表空间
create tablespace pgenius logging datafile '\data\oracle\oracledata\pgenius_0.dbf' size 1g, '\data\oracle\oracledata\pgenius_1.dbf' size 1m , '\data\oracle\oracledata\pgenius_2.dbf' size 1m , '\data\oracle\oracledata\pgenius_3.dbf' size 1m , '\data\oracle\oracledata\pgenius_4.dbf' size 1m , '\data\oracle\oracledata\pgenius_5.dbf' size 1m , '\data\oracle\oracledata\pgenius_6.dbf' size 1m , '\data\oracle\oracledata\pgenius_7.dbf' size 1m , '\data\oracle\oracledata\pgenius_8.dbf' size 1m , '\data\oracle\oracledata\pgenius_9.dbf' size 1m , '\data\oracle\oracledata\pgenius_10.dbf' size 1m dajinnylee.cn , '\data\oracle\oracledata\pgenius_11.dbf' size 1m , '\data\oracle\oracledata\pgenius_12.dbf' size 1m , '\data\oracle\oracledata\pgenius_13.dbf' size 1m , '\data\oracle\oracledata\pgenius_14.dbf' size 1m , '\data\oracle\oracledata\pgenius_15.dbf' size 1m , '\data\oracle\oracledata\pgenius_16.dbf' size 1m 6788878.cn , '\data\oracle\oracledata\pgenius_17.dbf' size 1m , '\data\oracle\oracledata\pgenius_18.dbf' size 1m , '\data\oracle\oracledata\pgenius_19.dbf' size 1m www.senta77.com autoextend on next 1g maxsize 16g extent management local;
删除表空间：
drop tablespace pgenius;//仅删除表空间drop tablespace pgenius including contents and datafiles; //同时删除数据文件
-
第3步：创建用户并指定表空间
create user yuhang identified by yuhang default tablespace yuhang_data temporary tablespace yuhang_temp;