PACKAGE: SYS.DBMS_REGISTRY_SYS

Source

1 PACKAGE dbms_registry_sys
2 AS
3 
4 PROCEDURE drop_user  (username IN VARCHAR2);
5 
6 PROCEDURE validate_catalog (b_upgrade IN BOOLEAN DEFAULT FALSE);
7 
8 PROCEDURE validate_catproc (b_upgrade IN BOOLEAN DEFAULT FALSE);
9 
10 PROCEDURE validate_rdbms_in_upgrade_mode (comp_id IN VARCHAR2);
11 
12 PROCEDURE validate_rdbms_in_normal_mode (comp_id IN VARCHAR2);
13 
14 PROCEDURE validate_catjava;
15 
16 PROCEDURE validate_components;
17 
18 FUNCTION  time_stamp   (comp_id IN VARCHAR2) RETURN VARCHAR2;
19 
20 FUNCTION  time_stamp_display (comp_id IN VARCHAR2) RETURN VARCHAR2;
21 
22 FUNCTION  time_stamp_comp_display (comp_id IN VARCHAR2) RETURN VARCHAR2;
23 
24 FUNCTION  dbupg_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
25 
26 FUNCTION  dbdwg_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
27 
28 FUNCTION  patch_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
29 
30 FUNCTION  relod_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
31 
32 FUNCTION  cpu_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
33 
34 FUNCTION  removal_script (comp_id IN VARCHAR2) RETURN VARCHAR2;
35 
36 PROCEDURE check_component_downgrades;
37 
38 PROCEDURE record_action (action    IN VARCHAR2,
39                          action_id IN NUMBER,
40                          comments  IN VARCHAR2);
41 
42 FUNCTION diagnostics RETURN NUMBER;
43 
44 PROCEDURE gather_stats (comp_id IN VARCHAR2);
45 
46 PROCEDURE populate;
47 
48 PROCEDURE populate_92;
49 
50 PROCEDURE populate_101;
51 
52 PROCEDURE populate_102;
53 
54 FUNCTION select_props_data (pname IN VARCHAR2) RETURN BOOLEAN;
55 
56 FUNCTION delete_props_data (pname IN VARCHAR2) RETURN BOOLEAN;
57 
58 FUNCTION insert_props_data (pname    IN VARCHAR2,
59                             pvalue   IN VARCHAR2,
60                             pcomment IN VARCHAR2) RETURN BOOLEAN;
61 
62 FUNCTION update_props_data (pname    IN VARCHAR2,
63                             pvalue   IN VARCHAR2) RETURN BOOLEAN;
64 
65 PROCEDURE set_registry_context (ctx_variable IN VARCHAR2,
66                                 ctx_value    IN VARCHAR2);
67 
68 FUNCTION get_pfile_path (dirname IN VARCHAR2) RETURN VARCHAR2;
69 
70 FUNCTION gen_pfile_from_memory RETURN VARCHAR2;
71 
72 FUNCTION utlmmig_script_name RETURN VARCHAR2;
73 
74 FUNCTION dir_exists_and_is_writable(dirname IN VARCHAR2) RETURN BOOLEAN;
75 
76 PROCEDURE resolve_catjava;
77 
78 END dbms_registry_sys;