Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
fozixovi
post Sep 12 2017, 10:04 AM
Post #1


Newbie
*

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:

CODE
SQL> SELECT tablespace_name FROM dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS


and since the tutorial gives this example:
CODE
SQL> @apexins SYSAUX SYSAUX TEMP /i/



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
burleson
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:

http://support.oracle.com

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