无法通过128（在表空间TABLESPACE_ZF中）扩展 temp 段

yulanhua

SQL>; create table test_large tablespace tablespace_zf as select * from t_for
e_repayplan;
create table test_large tablespace tablespace_zf as select * from t_fore_rep
ayplan
                                                                  *
ERROR 位于第 1 行:
ORA-01652: 无法通过128（在表空间TABLESPACE_ZF中）扩展 temp 段


table , 't_fore_repayplan' is a large table in tablespace1 ans its'size less than 78M.
both tablespace1 and tablespace_zf have definitly enough free space more than 78M.

rollingpig

hehe

原帖由 "oerr ora 01652" 发表：

01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause:  Failed to allocate an extent for temp segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//         files to the tablespace indicated.

guohualing

增加临时表空间