Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [07-2005 Date Index] [Date Next] || [Thread Prev] [07-2005 Thread Index] [Thread Next]

Re: Temp tbs with no temp file

  • From: Yechiel Adar <adar76@xxxxxxxxxxxx>
  • Date: Mon, 04 Jul 2005 15:32:38 +0200
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




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.