Re: Temp tbs with no temp file

IIRC you can define every tablespace as a place to use as temp for a user. Check out the default temporary tablespace in the users table.

My workstation lost it's C drive so I can not verify now.

Adar Yechiel
Rechovot, Israel

Sinardy wrote:

>My DB without temp file (tablespace) for like two months during this time
>where are the sorting being carried out? I know add temp file will work but
>just curious how come I can work without temp file.
>
>regards,
>Sinardy
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l