3 Replies Latest reply: Oct 31, 2012 12:45 PM by tx103108 RSS

    Oracle XE TEMP tablespace issue

    tx103108
      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
          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
            What does this give ? Check :
            select tablespace_name, file_name from dba_temp_files;
            • 3. Re: Oracle XE TEMP tablespace issue
              tx103108
              yes, there they are...thx