1 PACKAGE dbms_dimension authid current_user
2 IS
3 ----------------------------------------------------------------------------
4 -- public constants
5 ----------------------------------------------------------------------------
6 dimensionnotfound EXCEPTION;
7
8 ----------------------------------------------------------------------------
9 -- public procedures:
10 ----------------------------------------------------------------------------
11
12 ----------------------------------------------------------------------------
13 -- PROCEDURE DBMS_DIMENSION.DESCRIBE_DIMENSION
14 -- PURPOSE: prints out the definition of the input dimension, including
15 -- dimension owner and name, levels, hierarchies, attributes.
16 -- It displays the output via dbms_output.
17 -- PARAMETERS:
18 -- dimension: VARCHAR2
19 -- Name of the dimension, e.g. 'scott.dim1', 'scott.%', etc.
20 --
21 -- EXCEPTIONS:
22 -- dimensionnotfound The specified dimension was not found
23 PROCEDURE describe_dimension(dimension IN VARCHAR2);
24
25 ----------------------------------------------------------------------------
26 -- PROCEDURE DBMS_DIMENSION.VALIDATE_DIMENSION
27 -- PURPOSE: To verify that the relationships specified in a DIMENSION
28 -- are correct. Offending rowids are stored in advisor repository
29 -- PARAMETERS:
30 -- dimension: VARCHAR2
31 -- Owner and name of the dimension in the format of 'owner.name'.
32 --
33 -- incremental: BOOLEAN (default: TRUE)
34 -- If TRUE, then tests are performed only for the rows specified
35 -- in the sumdelta$ table for tables of this dimension; if FALSE,
36 -- check all rows.
37 --
38 -- check_nulls: BOOLEAN (default: FALSE)
39 -- If TRUE, then all level columns are verified to be non-null;
40 -- If FALSE, this check is omitted. Specify FALSE when non-nullness
41 -- is guaranteed by other means, such as NOT NULL constraints.
42 --
43 -- statement_id: VARCHAR2 (default: NULL)
44 -- A client-supplied unique identifier to associate output rows
45 -- with specific invocations of the procedure.
46 --
47 -- EXCEPTIONS:
48 -- dimensionnotfound The specified dimension was not found
49 --
50 -- NOTE: It is the 10i new interface. The 8.1 and 9i interfaces are deprecated,
51 -- but they should still remain working in 10i and after.
52 PROCEDURE validate_dimension
53 (
54 dimension IN VARCHAR2,
55 incremental IN BOOLEAN := TRUE,
56 check_nulls IN BOOLEAN := FALSE,
57 statement_id IN VARCHAR2 := NULL );
58
59 ----------------------------------------------------------------------------
60 -- PROCEDURE DBMS_DIMENSION.VALIDATE_DIMENSION
61 -- PURPOSE: To verify that the relationships specified in a DIMENSION
62 -- are correct. Offending rowids are stored in advisor repository
63 -- PARAMETERS:
64 -- dimension: VARCHAR2
65 -- Owner and name of the dimension in the format of 'owner.name'.
66 --
67 -- check_nulls: BOOLEAN (default: FALSE)
68 -- If TRUE, then all level columns are verified to be non-null;
69 -- If FALSE, this check is omitted. Specify FALSE when non-nullness
70 -- is guaranteed by other means, such as NOT NULL constraints.
71 --
72 -- statement_id: VARCHAR2 (default: NULL)
73 -- A client-supplied unique identifier to associate output rows
74 -- with specific invocations of the procedure.
75 --
76 -- EXCEPTIONS:
77 -- dimensionnotfound The specified dimension was not found
78 --
79 -- NOTE: It is the 10i new interface. The 8.1 and 9i interfaces are deprecated,
80 -- but they should still remain working in 10i and after.
81 PROCEDURE validate_dimension
82 (
83 dimension IN VARCHAR2,
84 check_nulls IN BOOLEAN := FALSE,
85 statement_id IN VARCHAR2 := NULL );
86
87 END dbms_dimension;