RE: a permanent tablespace as a temporary tablespace

You are right, it was upgraded from 8i three years ago. Everything is still Dictionary-managed. Thanks, Roger

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Grant Allen Sent: Friday, October 27, 2006 11:22 AM
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: Re: a permanent tablespace as a temporary tablespace

On 10/28/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:
>
>
> Hi,
>
> I inherited a SAP R/3 4.0B database in Solaris 9 / Oracle 9i.
> And it uses a permanent tablespace for temporary tablespace.
>
> Any comments and thoughts? It has been like this for at least
> 3 year and nobody report any problems because of this.

Two thoughts. Possibly the instance was upgraded from 8i (or earlier) ... 9i won't let you create a new user with temp tbs set to a perm tbs, but it's probably "kind" to existing users if the instance is upgraded (someone will doubtless correct me on this).

Secondly, if it ain't broke ...

Ciao
Fuzzy
:-)

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



This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security System.
--
http://www.freelists.org/webpage/oracle-l