Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
|
This chapter provides reference information about files that are used by Discoverer and includes the following topics:
A number of SQL files are installed with Oracle Discoverer Administrator and enable you to carry out specific database configuration tasks. The table below lists the SQL files and describes their functions.
The following files are located in the <ORACLE_HOME>\discoverer\util directory unless otherwise stated:
File name | Description |
---|---|
batchusr.sql |
Sets up a scheduled workbook results schema (for more information, see "How to specify the owner of the tables containing scheduled workbooks results"). |
dbmsjob.sql |
The interface for the Oracle DBMS JOB queue (for more information, see "How to confirm that the DBMS_JOB package is installed"). The dbmsjob.sql file is not installed with the database in the <ORACLE_HOME>\rdbms\admin directory. |
eul31del.sql |
Removes all Discoverer version 3.1 EUL objects that are no longer required with this version. |
eul4.sql |
Creates the functions required by the eul4.eex business area and workbooks (for more information, see "How to install the standard EUL status workbooks"). |
eul4del.sql |
Clears all 4.1 EUL objects (for more information, see "Upgrade step 5: Remove the Release 4.1 EULs"). |
eul5.sql |
Creates the functions required by the eul5.eex business area and its workbooks (for more information, see "How to install the standard EUL status workbooks"). |
eul5_apps.sql |
Creates the functions required by the eul5.eex business area and its workbooks when using an Oracle Applications EUL (for more information, see "How to install Oracle Applications EUL status workbooks"). Note: You use this script only with Oracle Applications EULs. |
eul5_id.sql |
Changes the reference number of an EUL. Use this script when you have used the database export and import utilities to copy an EUL and you want to:
Run the eul5_id.sql script to give a new reference number to the new EUL and thereby prevent any uniqueness conflicts in the above scenario (for more information, see "How to import an EUL using the standard database import utility"). |
eulasm.sql |
Grants the privileges required for summary folder management (and ASM) in Discoverer Administrator version 4.1 and later (for more information, see "How to use SQL*Plus and the eulasm.sql script to grant the privileges required to create summary folders"). |
eulgwreg.sql |
Contains a template EUL gateway registration script that you use when setting up EUL gateway metadata. For more information, see egwspec.doc and eulgatew.doc located in the <ORACLE_HOME>\discoverer\kits directory. |
eulgwtbl.sql |
Contains the template CREATE TABLE SQL statements that you use when setting up EUL gateway metadata. For more information, see egwspec.doc and eulgatew.doc located in the <ORACLE_HOME>\discoverer\kits directory. |
eulgwvue.sql |
Contains the template CREATE VIEW SQL statements that you use when setting up EUL gateway metadata. Note: If you execute this script without modifcation, it will not create a valid gateway. You must modify the SQL statement to correctly map the view columns to the metadata, in order to transfer information through the gateway. For more information, see egwspec.doc and eulgatew.doc located in the <ORACLE_HOME>\discoverer\kits directory. |
eulsown.sql |
Modifies summary folder ownership information that you might need if you export the EUL using the database export utility and import it into a different database user (for more information, see "How to export an EUL using the standard database export utility"). This script prompts you for the owner name of the summary folders in the source EUL, and for the owner name of the new summary folder in the target EUL (for more information, see "How to import an EUL using the standard database import utility"). |
eulstdel.sql |
Deletes query prediction statistics older than a specified age (for more information, see "How to delete old query prediction statistics"). |
eulsuqpp.sql |
Grants the necessary database privileges to enable query performance prediction (QPP) (for more information, see "How to use query prediction with secure views"). |
gwdrop.sql |
Enables you to delete an EUL gateway. For more information, see egwspec.doc and eulgatew.doc located in the <ORACLE_HOME>\discoverer\kits directory. |
gwgrant.sql |
Enables you to grant access to EUL gateways. For more information, see egwspec.doc and eulgatew.doc located in the <ORACLE_HOME>\discoverer\kits directory. |
lineage.sql |
You must run this script before using the lineage.eex business area and its workbook (for more information, see "Using Discoverer with Oracle Warehouse Builder"). |
If you work with Oracle Support to resolve a Discoverer issue, you will typically be asked for the following information:
In addition, Oracle Support might ask you to provide a trace file (for more information, see "How to create trace files to diagnose Discoverer problems").
Sometimes you might encounter a problem with Discoverer and be unable to identify the cause of the problem (e.g. a generic error message might not provide sufficient information). To provide more information about Discoverer problems, you can generate two types of trace file:
You can either use trace files yourself to diagnose the cause of the problem, or use trace files when working with Oracle Support.
To create an EUL trace file and/or a server trace file containing information relevant to the problem you are trying to resolve:
For more information about Discoverer registry settings, see "What are Discoverer registry settings?".
|
Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
|