Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
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.
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.
Syntax
ALLCOMPILE [n]
Arguments
An INTEGER
expression with a value of zero or higher. The expression specifies the number of objects to be compiled before an UPDATE statement is executed. For example, when you specify 1
, an UPDATE statement is executed after each object is compiled. When you specify 0
(zero), all the objects are compiled and an UPDATE statement is executed only at the end. When you omit the argument, no UPDATE statement is executed by ALLCOMPILE. Frequent updates during an ALLCOMPILE help ensure the most efficient use of space in the analytic workspace.
Examples