Re: Temp tbs with no temp file

  • From: "Sinardy" <all_about_oracle@xxxxxxxxxx>
  • To: <zhuchao@xxxxxxxxx>, <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • Date: Mon, 4 Jul 2005 13:58:17 +0800

No, this is general normal DB behavior and nothing to do with RMAN nor
standby DB.

Just don't understand why Oracle can be open with temp or perm tablespace
without datafile. Never mention (can't find) such behavior in Concept and
Admin guide.
I even performed sorting wihtout the temp tablespace, I remember I did
export and import then write few package and compile, insert and delete,
select order by, group by, join table ect..
just curious where are those sorting being carried out?

May be Oracle never update the document for this new feature. Or perhaps I
miss something and just learn new thing.

----- Original Message ----- 
From: "zhu chao" <zhuchao@xxxxxxxxx>
To: <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
Cc: <all_about_oracle@xxxxxxxxxx>; "Mladen Gogala" <gogala@xxxxxxxxxxxxx>;
"Oracle-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, July 04, 2005 1:44 PM
Subject: Re: Temp tbs with no temp file

> Or from oracle standby activate also have the same problem.
> On 7/1/05, Reidy, Ron <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:
> > Could this have been a RMAN duplicate?
> >
> -- 
> Regards
> Zhu Chao
> --


Other related posts: