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;
       就好了
请使用浏览器的分享功能分享到微信等