Re: Temp tbs with no temp file

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_at_gmail.com> To: <Ron.Reidy_at_arraybiopharma.com> Cc: <all_about_oracle_at_hotpop.com>; "Mladen Gogala" <gogala_at_sbcglobal.net>; "Oracle-L" <oracle-l_at_freelists.org> 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_at_arraybiopharma.com> wrote:
> > Could this have been a RMAN duplicate?
> >
> --
> Regards
> Zhu Chao
> www.cnoug.org
> --
> http://www.freelists.org/webpage/oracle-l

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