1 PACKAGE HRI_UTL_DDL AUTHID CURRENT_USER AS
2 /* $Header: hriutddl.pkh 120.1 2006/01/20 02:05:06 jtitmas noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- PROCEDURE recreate_indexes
6 -- -----------------------------------------------------------------------------
7 --
8 -- This procedure recreates the indexes for the specified table using the
9 -- definitions stored in the temporary table
10 --
11 -- Parameter Type Description
12 -- ------------------------ ---- ---------------------------------------------
13 -- p_application_short_name IN Short name of the application product
14 -- calling this routine
15 -- p_table_name IN Table for which the indexes are to be dropped
16 -- p_table_owner IN Name of the Schema owning the table
17 -- -----------------------------------------------------------------------------
18 --
19 PROCEDURE recreate_indexes(p_application_short_name IN VARCHAR2,
20 p_table_name IN VARCHAR2,
21 p_table_owner IN VARCHAR2);
22 --
23 -- -----------------------------------------------------------------------------
24 -- PROCEDURE log_and_drop_indexes
25 -- -----------------------------------------------------------------------------
26 --
27 -- This procedure drops all the indexes for a table and inserts definition
28 -- of the indexes in a temporary table. Using this definition the procedure
29 -- recreate_indexes can recreate the indexes. If some of the indexes are not
30 -- to be dropped, a comma separated list can be passed in parameter
31 -- p_index_excptn_lst.
32 --
33 -- NOTE: The procedure will not drop the primary key index.
34 --
35 -- Parameter Type Description
36 -- ------------------------ ---- ---------------------------------------------
37 -- p_application_short_name IN Short name of the application product
38 -- calling this routine
39 -- p_table_name IN Table for which the indexes are to be dropped
40 -- p_table_owner IN Name of the Schema owning the table
41 -- p_index_excptn_lst IN Pass a comma separated list of indexes which
42 -- are not to be dropped
43 -- -----------------------------------------------------------------------------
44 --
45 PROCEDURE log_and_drop_indexes(p_application_short_name IN VARCHAR2,
46 p_table_name IN VARCHAR2,
47 p_table_owner IN VARCHAR2,
48 p_index_excptn_lst IN VARCHAR2 DEFAULT NULL);
49 --
50 PROCEDURE maintain_mthd_partitions(p_table_name IN VARCHAR2,
51 p_table_owner IN VARCHAR2);
52 --
53 END HRI_UTL_DDL;
[Home] [Help]