Database Administration (MOSC)

MOSC Banner

Ghost temp tablespace in database

edited May 22, 2014 5:18AM in Database Administration (MOSC) 11 commentsAnswered ✓


We are running oracle EBS version 12.1.3 with oracle database version 11.2.0.3

I am running into an strange and interesting situation where I am trying to chasing down the ghost temp tablespace.

select username, default_tablespace, temporary_tablespace from dba_users order by username;

USERNAME                       DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE
------------------------------ ------------------------------ ------------------------------
XXFND                          XX_TS_DATA                     TEMP
XXGL                           XX_TS_DATA                     TEMP
XXINV                          XX_TS_DATA                     TEMP

SQL> select tablespace_name from dba_tablespaces where tablespace_name like 'TEMP%';

TABLESPACE_NAME
------------------------------
TEMP1
TEMP2

SQL> select file_name, file_id, bytes, status, autoextensible from dba_temp_files where tablespace_name='TEMP';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center