Yesterday I dropped the Temporary tablespace and its related datafiles and I created exactly the same way and ran my query. I have not added extra datafiles or resized or eliminated..

Ran for 6 hrs and failed due to a filesystem error.. Looks like this formula worked for ORA-01114. Today I shall run again to make sure.

Thanks, ST2000