大佬们都有很多文章了，我把我的也分享一下，主要包含当数据库文件超了30G的解决办法。
### 创建表空间
```sql
create tablespace EASxxx_D_EAS_TEMP2
logging
datafile 'F:\EASDateBaseFile\EASxxx\xxx_D_EAS_TEMP2.dbf'
size 500m
autoextend on
next 50m maxsize unlimited
extent management local;
create tablespace EASxxx_D_EAS_STANDARD
logging
datafile 'F:\EASDateBaseFile\EASxxx\xxx_D_EAS_STANDARD.dbf'
size 1000m
autoextend on
next 50m maxsize unlimited
extent management local;
Create temporary tablespace EASxxx_T_EAS_STANDARD
tempfile 'F:\EASDateBaseFile\EASxxx\xxx_T_EAS_STANDARD.ORA'
size 500m
autoextend on
next 50m maxsize unlimited
extent management local;
Create tablespace EASxxx_D_EAS_INDEX
logging
datafile 'F:\EASDateBaseFile\EASxxx\xxx_D_EAS_INDEX.ORA'
size 500M
autoextend on
next 50m maxsize unlimited
extent management local;
-- 当数据文件大于30G的时候，要再建一个表空间
alter tablespace EASxxx_D_EAS_STANDARD add datafile 'F:/EASDateBaseFile/EASxx/EASxxx_D_EAS_STANDARD_1.dbf' size 30G;
```
### 创建用户,并制定用户默认的表空间
```sql
CREATE USER EASxxx IDENTIFIED BY 123 DEFAULT TABLESPACE EASxxx_D_EAS_STANDARD TEMPORARY TABLESPACE EASxxx_T_EAS_STANDARD
