My Oracle Support Banner

DWSTAGE Schema Currently Has Too Many Tables - Guidance On Maintenance Required (Doc ID 2662868.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.9 and later
Information in this document applies to any platform.

Symptoms

On : 2.7.0.0.9 version, Install / Upgrade

ACTUAL BEHAVIOR
---------------
Temporary tables are created all the time by ETL execution and ODI does not appear to clear them. Currently there are lots of tables in the DWADM schema.

EXPECTED BEHAVIOR
-----------------------
What are the maintenance steps that can be taken to remove the no longer required tables?

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ETL and ODI does not clean the Temp tables.
2. Temp tables getting larger.

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.