This discussion is archived
3 Replies Latest reply: Oct 31, 2012 10:45 AM by tx103108 RSS

Oracle XE TEMP tablespace issue

tx103108 Newbie
Currently Being Moderated
Oracle XE 11gR2
Linux RHEL 5.8
-----------------------

The following SQL shows a TEMP tablespace exists:

select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
APEX

but the following shows no datafiles associated with the TEMP tablespace:

select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME FILE_NAME
-----------------------------------------------------
USERS /u01/app/oracle/oradata/XE/users.dbf

SYSAUX /u01/app/oracle/oradata/XE/sysaux.dbf

UNDOTBS1 /u01/app/oracle/oradata/XE/undotbs1.dbf

SYSTEM /u01/app/oracle/oradata/XE/system.dbf

APEX /u01/app/oracle/product/11.2.0/xe/dbs/APEX01.dbf

What gives? I chose the default configuration of Oracle XE out-of-the box. If this is ok (??) where is the sorting done in Oracle XE?
Thank u
  • 1. Re: Oracle XE TEMP tablespace issue
    sb92075 Guru
    Currently Being Moderated
    user601798 wrote:
    Oracle XE 11gR2
    Linux RHEL 5.8
    -----------------------

    The following SQL shows a TEMP tablespace exists:

    select tablespace_name from dba_tablespaces;

    TABLESPACE_NAME
    ------------------------------
    SYSTEM
    SYSAUX
    UNDOTBS1
    TEMP
    USERS
    APEX

    but the following shows no datafiles associated with the TEMP tablespace:

    select tablespace_name, file_name from dba_data_files;

    TABLESPACE_NAME FILE_NAME
    -----------------------------------------------------
    USERS /u01/app/oracle/oradata/XE/users.dbf

    SYSAUX /u01/app/oracle/oradata/XE/sysaux.dbf

    UNDOTBS1 /u01/app/oracle/oradata/XE/undotbs1.dbf

    SYSTEM /u01/app/oracle/oradata/XE/system.dbf

    APEX /u01/app/oracle/product/11.2.0/xe/dbs/APEX01.dbf

    What gives? I chose the default configuration of Oracle XE out-of-the box. If this is ok (??) where is the sorting done in Oracle XE?
    Thank u
    select tablespace_name, file_name from dba_TEMP_files;
  • 2. Re: Oracle XE TEMP tablespace issue
    Shivananda Rao Guru
    Currently Being Moderated
    What does this give ? Check :
    select tablespace_name, file_name from dba_temp_files;
  • 3. Re: Oracle XE TEMP tablespace issue
    tx103108 Newbie
    Currently Being Moderated
    yes, there they are...thx

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points