Is There Any Program to Drop Temporary Tables Which Are No Longer Required? (Doc ID 416542.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle General Ledger - Version 11.5.9 and later
Information in this document applies to any platform.

Goal

You have some interim tables in the system which are not dropped by the processes in Oracle General Ledger which created and used them.

Some of these tables can be identified using the following scripts:

Is there any Concurrent Request or Program which can help in dropping these tables which are no longer necessary.

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