My Oracle Support Banner

Reorganization of Tablespaces in Fusion Applications (Doc ID 2309713.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Fusion Financials Common Module - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Administrators want to reorganize tablespaces to free up space within datafiles. Should tables and indexes stay in their original tablespaces?  Will moving segments to new table spaces cause any problems with Fusion Applications or future patching?

For example, can we create a FUSION_TS_TX_DATA2 tablespace and move FUSION_TS_TX_DATA tables to it.
Another alternative is to  create a FUSION_TS_TX_IDX2 table space and move FUSION_TS_TX_IDX indexes to it.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.