1 PACKAGE JTF_TAE_INDEX_CREATION_PVT AUTHID CURRENT_USER AS
2 /*$Header: jtftaeis.pls 120.0 2005/06/02 18:21:12 appldev ship $*/
3 /* -- =========================================================================+
4 -- | Copyright (c) 2002 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +===========================================================================
8 -- Start of Comments
9 -- ---------------------------------------------------
10 -- PACKAGE NAME: JTF_TAE_INDEX_CREATION_PVT
11 -- ---------------------------------------------------
12 -- PURPOSE
13 --
14 -- This package is used to return a list of column in order of selectivity.
15 -- And create indices on columns in order of input
16 --
17 --
18 -- Procedures:
19 -- (see below for specification)
20 --
21 -- NOTES
22 -- This package is publicly available for use
23 --
24 -- HISTORY
25 -- 05/02/2002 SHLI Created
26 --
27 -- End of Comments */
28
29 Type value_varray IS VARRAY (30) of integer;
30 TYPE name_varray IS VARRAY (30) OF varchar2(25);
31
32 FUNCTION SELECTIVITY(p_TABLE_NAME IN VARCHAR2) return number;
33
34 procedure CREATE_INDEX ( p_table_name IN VARCHAR2,
35 p_trans_object_type_id IN NUMBER,
36 p_source_id IN NUMBER,
37 x_Return_Status OUT NOCOPY VARCHAR2,
38 p_run_mode IN VARCHAR2 := 'TAP');
39
40 PROCEDURE DROP_TABLE_INDEXES( p_table_name IN VARCHAR2
41 , x_return_status OUT NOCOPY VARCHAR2 );
42
43 PROCEDURE ANALYZE_TABLE_INDEX( p_TABLE_NAME IN VARCHAR2,
44 P_PERCENT IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2 );
46
47 PROCEDURE TRUNCATE_TABLE( p_TABLE_NAME IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2 );
49
50 END JTF_TAE_INDEX_CREATION_PVT;
51