Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALLCOMPILE

The ALLCOMPILE program compiles every compilable object in your current analytic workspace, one at a time. As it works, ALLCOMPILE sends to the current outfile messages that show the name of the object being compiled.

Syntax

ALLCOMPILE [n]

Arguments

n

An INTEGER expression with a value of zero or higher. The expression specifies the number of objects to be compiled before an UPDATE command is executed. For example, when you specify 1, an UPDATE command is executed after each object is compiled. When you specify 0 (zero), all the objects are compiled and an UPDATE command is executed only at the end. When you omit the argument, no UPDATE command is executed by ALLCOMPILE. Frequent updates during an ALLCOMPILE help ensure the most efficient use of space in the analytic workspace.

Notes


Error Messages

ALLCOMPILE uses the COMPILE command. This means that it will check for syntax errors as it compiles an object, and it will record error messages in the current outfile as appropriate.

Examples

Example 7-14 ALLCOMPILE Output

The following example shows the output of ALLCOMPILE when it is run on an analytic workspace that contains four programs.

Compiling AUTOGO
Compiling READIT
Compiling REGION.REPORT
Compiling SALES.REPORT