Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Without TEMP tablespace

Anjan SilJan 17 2007 — edited Jan 17 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2007
Added on Jan 17 2007
7 comments
1,992 views