cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
537
Views
0
Helpful
0
Comments
TCC_2
Level 10
Level 10

Core Issue

The 'full_path_for_tablespace' value is very important to know if the size of table space must be expanded in the Oracle database when the Service Agent (SA) 2.0 Master Provisioning Data Store (MPDS) is used.

Resolution

To query for 'full_path_for_tablespace' in both Oracle databases, perform these steps:

  1. Use the SQLPlus program to log into both Oracle databases as the "system" user.
  2. Run this command:

    SQL> select tablespace_name, file_name from dba_data_files where tablespace_name = 'tablespace_name';

    For example,

    SQL> select tablespace_name, file_name from dba_data_files where tablespace_name = 'USERS';

    SQL> /db002/oradata/database1/users01.dbf

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: