Re: a permanent tablespace as a temporary tablespace

From: Grant Allen <gxallen_at_gmail.com>
Date: Sat, 28 Oct 2006 02:21:46 +1000
Message-ID: <e2451e6a0610270921y58982abbl6687e4b11577ac1c@mail.gmail.com>

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

Received on Fri Oct 27 2006 - 11:21:46 CDT