Can SOA12c DB Partitions dropped Without Disabling FKs?
(Doc ID 2850712.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle SOA Suite - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Goal
As described in https://docs.oracle.com/en/middleware/soa-suite/soa/12.2.1.4/administer/managing-database-growth.html#GUID-FA249DA0-A343-448A-8218-D84E09194FB2, after running verification script (15.4.9 Running the Verification Script) a result log is created containing the status of every DB partition: PASS if it can be dropped or FAILED if cannot.
The next step is now to drop the partitions that can be dropped. As per the mentioned document:
The question here is if the drop script can be executed only for pass partition with zero records, without disable the FKs.
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 |
| References |