Re: Temp tbs with no temp file

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

• Original Message ----- From: "Mladen Gogala" <gogala_at_sbcglobal.net> To: "zhu chao" <zhuchao_at_gmail.com> Cc: <Ron.Reidy_at_arraybiopharma.com>; <all_about_oracle_at_hotpop.com>; "Mladen Gogala" <gogala_at_sbcglobal.net>; "Oracle-L" <oracle-l_at_freelists.org> Sent: Monday, July 04, 2005 2:05 PM Subject: Re: Temp tbs with no temp file

>
> On 07/04/2005 01:44:54 AM, zhu chao wrote:
> > Or from oracle standby activate also have the same problem.
>
> Of course you have the same problem when you activate the standby
database!
> Blocks in temporary tablespaces are not protected by redo logs. That means
> that changes of blocks in the temporary tablespace are not written into
redo log
> files. Consequently, you cannot find them in the archived redo log files,
which
> means that standby database doesn't need them. You can simply add a new
one and
> everything will be OK. I don't see what is the problem? Tempfiles are a
convenient,
> can be easily handled and you shouldn't care if you lose them. What
exactly is
> the problem when activating standby?
> --
> Mladen Gogala
> http://www.mgogala.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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