Query from Oracle Reports caused temp tablespace to be full

Hi all,
Has anyone had any similar problem with running a query from Oracle reports that cause the Temp tablespace to get full? The same query sometimes run in seconds without any problem and another time it caused the temp to be full with around 1GB. The records in the tables are really few and i dont expect any problem even if we have many joins.

The error that we received is:
ORA-01237 cannot extend datafile 4 '/data/...../temp01.dbf ORA-19502: write error on file '/data/...../temp01.dbf

Any help will be appreciated. Received on Tue May 01 2001 - 02:00:44 CDT