My Oracle Support Banner

It is supported to move a SOA 12.2.1.4.0 table and lob to a new tablespace? (Doc ID 3067997.1)

Last updated on JANUARY 21, 2025

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

 It is supported to move a SOA table and lob to a new tablespace?

This is a filesystem space issue that impacts the SOA DB repository, so it is required to shrink the tablespaces but more space is needed.
For that reason, it is supported to move a SOA table and a lob to a new tablespace?

Here it is required to create a new tablespace in a filesystem with more free space and move the lob segment SYS_LOB0000078098C00010$$ associated with table WFTASKRETRY and later to execute the shrink process. Is this allowed? (this operation will be done having SOA Server down). When SOA Server is started again, it will work fine again?

Cause

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
Symptoms
Cause
Solution
References


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