Re: apex 5.0 installation

Posted by Roshan on Mar 04, 2016; 3:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/apex-5-0-installation-tp648p650.html

When I do SQL> select tablespace_name from dba_tablespaces;
TEMP tablespace is not present. Below is the result:

TABLESPACE_NAME
------------------------------
SYSTEM
CTXD
OWAPUB
TEMP1
ODM
PORTAL
APPS_UNDOTS1
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_SEED
APPS_TS_INTERFACE

TABLESPACE_NAME
------------------------------
APPS_TS_SUMMARY
APPS_TS_NOLOGGING
APPS_TS_ARCHIVE
APPS_TS_QUEUES
APPS_TS_MEDIA
OLAP
SYSAUX
APPS_TS_TOOLS
TEMP2
APEX
APEX_FILES

when I do:
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE
   PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

I gives me:
PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TEMP