a permanent tablespace as a temporary tablespace

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Fri, 27 Oct 2006 10:13:58 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70AAF286A@irv2kexch01.tx.bg.corp>

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.

a629pse0:oraps1 3% sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 27 10:06:45 2006

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> select USERNAME,TEMPORARY_TABLESPACE from dba_users;

USERNAME                       TEMPORARY_TABLESPACE


------------------------------ ------------------------------

SYS                            PSAPTEMPD
SYSTEM                         PSAPTEMPD
SAPR3                          PSAPTEMPD
OPS$PS1ADM                     PSAPTEMPD
DBSMON                         PSAPTEMPD
DBSNMP                         PSAPTEMPD
OUTLN                          PSAPTEMPD
OPS$ORAPS1                     PSAPTEMPD
THEGUARD                       PSAPTEMPD
NEXUS                          PSAPTEMPD

10 rows selected.

SQL> select CONTENTS,EXTENT_MANAGEMENT,SEGMENT_SPACE_MANAGEMENT 2 from dba_tablespaces
3 where tablespace_name = 'PSAPTEMPD';

CONTENTS EXTENT_MAN SEGMEN
--------- ---------- ------

PERMANENT DICTIONARY MANUAL SQL> select TABLESPACE_NAME from dba_tablespaces where CONTENTS != 'PERMANENT';

no rows selected

SQL> select count(*) from dba_temp_files;

COUNT(*)

Thanks,
Roger

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 Received on Fri Oct 27 2006 - 10:13:58 CDT