Fusion Applications - HOW TO MAINTAIN TABLES IN FUSION_DYNAMIC DATABASE SCHEMA (Doc ID 2183047.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Fusion Financials Common Module - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.9.2.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.

Two questions:
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?
 

Solution

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