My Oracle Support Banner

How To Identify Which Scheduled Workbooks And User Are Associated With Which Database View / Result Set (Doc ID 747806.1)

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Discoverer - Version to [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***


Is it possible to identify the particular scheduled workbook which is associated with the EUL batch database objects?

For example, when a Discoverer workbook is scheduled the following database objects are created:

All these objects have the same unique sequence number within the object name.

The objects are created in the schema specified in the Discoverer Administrator under Tools ->
Privileges -> "Scheduled Workbooks" tab -> under  user that "owns the tables which store scheduled workbook results."

There could be many result set tables created under the same schema.

Note: The tables mentioned here should never be manually updated or deleted.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.