We were getting the following error in our ColdFusion
“Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-01652: unable to extend temp segment by 384 in tablespace TEMP The specific sequence of files included or processed is: /htdocs/coldfusion.cfm”
The fix our DBA did was the following as the DBA user:
> select file_name, bytes from dba_data_files where tablespace_name = ‘TEMP’;
> alter database datafile ‘<file_name from above query, include the full path>’ resize <compute the new size based on the above query, original size + 30%, enter as-for example 100m>;