How to expand the size of tablespace in SA 2.0 MPDS databases

[TCC_2]

Core Issue

The tablespace in the Service Agent (SA) Master Provisioning Data Store (MPDS) is too small and needs to be expanded.

Resolution

To expand the size of the SA MPDS tablespace, perform these steps:

1. Login to both Oracle databases through SQLPlus (enter "sqlplus" to do this) as the "system" user.
   
   
2. Run the alter database datafile 'full_path_for_tablespace' resize size_in_M; command.
   
   For example:
   
   SQL> alter database datafile '/db002/oradata/database1/users01.dbf' resize 200M;

Notes: TAC Case Collection (TAC CC) case K20828058 addresses how to query for full_path_for_tablespace.

TAC CC case K73395148 addresses how to query for current tablespace in the database.