Why I cannot increase the size of a temp file for temp tablespace?
672869Mar 9 2009 — edited Mar 9 2009I got "ORA-1652: unable to extend temp segment by 128 in tablespace TEMP" in alert log file. Then I tried to add more space to the existing temp tablespace which is at 2GB in size with this command, but got error:
alter database TEMPFILE '/n3db02/oradata/cntnp/temp01.dbf' resize 2500m
*
ERROR at line 1:
ORA-01237: cannot extend datafile 201
ORA-01110: data file 201: '/n3db02/oradata/cntnp/temp01.dbf'
ORA-27059: could not reduce file size
SVR4 Error: 27: File too large
Additional information: 2
The directory has enough space to add. I can add another file to the temp tablespace, but not to the existing file at only 2GB. Can anybody tell why?
Thanks for advise,