[Home] [Help]
PACKAGE: APPS.POA_MV_UTILS_PKG
Source
1 package POA_MV_UTILS_PKG as
2 /* $Header: POAMVUTLS.pls 120.0 2005/06/01 13:40:49 appldev noship $ */
3
4 procedure drop_MV_Log(p_mv_log varchar2);
5
6 procedure create_MV_Log(p_base_table varchar2
7 ,p_column_list varchar2 := NULL
8 ,p_sequence_flag varchar2 := 'Y'
9 ,p_rowid varchar2 := 'Y'
10 ,p_new_values varchar2 := 'Y'
11 ,p_data_tablespace varchar2 := null
12 ,p_index_tablespace varchar2 := null
13 ,p_next_extent varchar2 := '32K'
14 );
15
16 procedure drop_MV(p_mv varchar2);
17
18 procedure create_part_MV(p_mv_name varchar2
19 ,p_mv_sql varchar2
20 ,p_build_mode varchar2 := 'D' -- D = DEFERRED, I = IMMEDIATE
21 ,p_refresh_mode varchar2 := 'F' -- F = FAST , C = COMPLETE
22 ,p_enable_qrewrite varchar2 := 'N'
23 ,p_partition_clause varchar2 := NULL
24 ,p_next_extent varchar2 := '2M'
25 );
26
27 procedure create_MV(p_mv_name varchar2
28 ,p_mv_sql varchar2
29 ,p_build_mode varchar2 := 'D' -- DEFERRED
30 ,p_refresh_mode varchar2 := 'F' -- FAST
31 ,p_enable_qrewrite varchar2 := 'N'
32 ,p_partition_flag varchar2 := 'N'
33 ,p_next_extent varchar2 := '2M'
34 ) ;
35
36 procedure create_MV_Index(p_mv_name varchar2
37 ,p_ind_name varchar2
38 ,p_ind_col_list varchar2
39 ,p_unique_flag varchar2 := 'N'
40 ,p_ind_type varchar2 := 'B' -- B = BTree , M = BitMap
41 ,p_next_extent varchar2 := '32K'
42 ,p_partition_type varchar2 := 'L'
43 );
44 end POA_MV_UTILS_PKG;