Re: apex 5.0 installation

Posted by ErmanArslansOracleBlog on Mar 04, 2016; 4:54am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/apex-5-0-installation-tp648p651.html

You have a temp tbs group consists of temp1 and temp2 . check from dba_tablespace_groups.

Add tempfile to temp1 and temp2 , if they dont have one

4 Mar 2016 05:28 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/apex-5-0-installation-tp648p650.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML