Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> I'm not sure about how to get tablespaces names
post Sep 12 2017, 10:04 AM
Post #1


Group: Possible Spammers
Posts: 1
Joined: 12-September 17
Member No.: 52,163

I know nothing about oracle. i'm just starting.

I'm trying to upgrade APEX, and I need this information to do that (highlighted in red):

tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
tablespace_files is the name of the tablespace for the Oracle Application Express files user.
tablespace_temp is the name of the temporary tablespace or tablespace group.
images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.

The question is: how do I find that data?

I'm following this tutorial

From what I had investigated, some tablespaces names are obtained from this command:

SQL> SELECT tablespace_name FROM dba_tablespaces;


and since the tutorial gives this example:

I guess that

tablespace_apex = SYSAUX
tablespace_files = SYSAUX
tablespace_temp = TEMP
images = /i/

But I'm not sure about that, and if correct, I don't know which names correspond to those variables.

May you clarify it?
Go to the top of the page
+Quote Post
post Sep 12 2017, 06:07 PM
Post #2

Advanced Member

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13

Hi, and welcome to the forum!

To be sure about the tablespaces, query dba_tables for the owner, tablespace_nameband table_name, where table_name='wwv_flow_files';

This will return the location of the apex schema objects.

Just be careful, upgrading apex requires a trained DBA.

if you need technical support, just log a service request on MOSC:


Good luck!

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 23rd September 2017 - 10:14 PM