Is the TEMP data file mandatory in oracle? what problems that can happen if you dont have one.
I noticed one DB had a TEMP tablespace but there was no data file assigned or were deleted.
would this create issue or all SORTS and JOINS happenin the SGA.
What is the standard size or command for creating the TEMP file if i must do it.