Without TEMP tablespace
Hi,
I've a query, is it possible to run a database without any TEMP tablespace? I've newly assigned as a DBA of one database where I do not find any temporary tablespace.
The following queries giving "no rows selected":
1. select * from v$tempfile ;
2. select * from dba_tablespaces where contents='TEMPORARY' ;
It is really very helpful to me if I get the answer whether a database may have no TEMP tablespace. If yes, then how it handles the jobs of TEMP tablespace and if no, then how can I know the TEMP file.
Thanks in advance..
Regards,
Anjan