Fusion Applications - HOW TO MAINTAIN TABLES IN FUSION_DYNAMIC DATABASE SCHEMA
Last updated on MARCH 21, 2017
Applies to:Oracle Fusion Financials Common Module - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Technology Management - System Administration
In the FUSION_DYNAMIC database schema there are about 150.000 empty tables using 40 GB of the FUSION_DYN_TS tablespace.
1. Can I just delete the tables on the fly?
2. Is there a way of getting these tables cleaned up automatically when not in use any longer?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms