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