Ghost temp tablespace in database
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';