RE: a permanent tablespace as a temporary tablespace
- From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
- To: <gxallen@xxxxxxxxx>, "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Oct 2006 11:24:58 -0500
You are right, it was upgraded from 8i three years ago.
Everything is still Dictionary-managed. Thanks, Roger
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Grant Allen
Sent: Friday, October 27, 2006 11:22 AM
To: Oracle-L@Freelists. Org (E-mail)
Subject: Re: a permanent tablespace as a temporary tablespace
On 10/28/06, Roger Xu <Roger.Xu@xxxxxxxxxxx> 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
:-)
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
