ORA-01652: 無法通過 8 (在表空間 TONGYIHUA 中) 擴充套件 temp 段

 在行 90 上開始執行命令時出錯:
Create Table R_Resourcecontent_Bak As Select * From R_Resourcecontent
命令出錯, 行: 90 列: 52
錯誤報告:
SQL 錯誤: 01652. 00000 -  "unable to extend temp segment by %s in tablespace %s"
*Cause:    Failed to allocate an extent of the required number of blocks for
           a temporary segment in the tablespace indicated.
*Action:   Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
           Files To The Tablespace Indicated.

 

 

1，我先alter database datafile 7 autoextend on;

      仍報以上錯誤

2，又用alter tablespace tongyihua add datafile '/oracle/x/tongyihua2.dbf' size 2g;

       就好了