Posted by
ErmanArslansOracleBlog on
Mar 04, 2016; 5:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/apex-5-0-installation-tp648p659.html
I see the sql;
It does the control with this statement:
select p_def_tablespace tbs_name from dual
where upper(p_def_tablespace) not in
(select tablespace_name from sys.dba_tablespaces where tablespace_name = upper(p_def_tablespace)))
So, you can do as I suggested, but you can also change the default temporary tablespace from TEMP to TEMP1 or TEMP2, as it is documented in
https://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#AELIG7015
ords_params.properties file:
Make any desired values to default values to reflect your environment and preferences. If you change any of the tablespace-related values, you must ensure that the tablespaces you specify already exist in the database.
The default ords_params.properties file includes the following:
db.hostname=localhost
db.port=1521
db.servicename=
db.sid=
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP --> SO YOU CAN CHANGE THIS TO TEMP1 or TEMP2
standalone.http.port=8080
standalone.mode=true
standalone.static.images=
user.tablespace.default=USERS
user.tablespace.temp=TEMP