What are the prerequisites for creating summary folders manually in Discoverer?
To create summary folders, the following requirements must be met: The database must support PL/SQL. The DBMS_JOB package must be installed for scheduling summary folder creation and refresh. For more information see Chapter 13, “How to confirm that DBMS_JOB is installed for summary management”. The User ID that you intend to use to create the summary folders must have the following database privileges: CREATE TABLE CREATE VIEW CREATE PROCEDURE SELECT ON V_$PARAMETER CREATE/DROP/ALTER ANY MATERIALIZED VIEW (Oracle 8.1.7 (or later) Enterprise Edition databases) GLOBAL QUERY REWRITE (Oracle 8.1.7 (or later) Enterprise Edition databases) For more information, see Chapter 13, “How to use SQL*Plus to grant the privileges required to create summary folders”. The User ID that you intend to use to create the summary folders must have sufficient quota in their default tablespace. For more information, see Chapter 13, “How to determine and reset tablespace quotas”.
Related Questions
- What is the difference between creating an assignment item as "AVAILABLE in students assignment folders: YES/NO"?
- Why can I see any of my working folders or tasks when creating an Outlook query in Tasktop?
- Why can I see any of my working folders or tasks when creating an Outlook query in Tasktop?
- What are the prerequisites for creating summary folders manually in Discoverer?
- What are the prerequisites for using Oracle Discoverer?
- What are the prerequisites for using Oracle Discoverer?
