FreeLists / oracle-l / Re: Temp tbs with no temp file

["Sinardy" <all_about_oracle@xxxxxxxxxx>]

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@xxxxxxxxxxxxx>
To: "zhu chao" <zhuchao@xxxxxxxxx>
Cc: <Ron.Reidy@xxxxxxxxxxxxxxxxxx>; <all_about_oracle@xxxxxxxxxx>; "Mladen
Gogala" <gogala@xxxxxxxxxxxxx>; "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
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