[Home] [Help]
PACKAGE: SYSTEM.AD_CLONE_UTILS
Source
1 package AD_CLONE_UTILS AUTHID CURRENT_USER as
2 -- $Header: adclutls.pls 120.0 2005/05/25 11:57:15 appldev noship $
3
4 --
5 -- package constants for CLONE, SYNC, SWAP statuses
6 --
7 SOURCE_SCHEMA_TYPE CONSTANT varchar2(30) := 'SOURCE';
8 CLONE_SCHEMA_TYPE CONSTANT varchar2(30) := 'CLONE';
9 SPEC_SCHEMA_TYPE CONSTANT varchar2(30) := 'SPEC';
10
11 CLONE_PHASE CONSTANT varchar2(30) := 'CLONE';
12 MERGE_PHASE CONSTANT varchar2(30) := 'MERGE';
13 SYNC_PHASE CONSTANT varchar2(30) := 'SYNC';
14 UNKNOWN_PHASE CONSTANT varchar2(30) := 'UNKNOWN';
15
16 STATUS_UNKNOWN CONSTANT varchar2(30) := 'UNKNOWN';
17 STATUS_COMPLETED CONSTANT varchar2(30) := 'COMPLETED';
18 STATUS_INCOMPLETE CONSTANT varchar2(30) := 'INCOMPLETE';
19 STATUS_FAILED CONSTANT varchar2(30) := 'FAILED';
20 STATUS_INPROGRESS CONSTANT varchar2(30) := 'INPROGRESS';
21
22 function get_db_version return varchar2;
23
24 procedure println(X_msg in varchar2);
25
26 procedure clone_table(X_table_name in varchar2,
27 X_from_schema in varchar2,
28 X_to_schema in varchar2,
29 X_from_APPS_schema in varchar2,
30 X_to_APPS_schema in varchar2,
31 X_copy_pk_cons in boolean default TRUE,
32 X_preserve_partitions in boolean default TRUE,
33 X_data_tablespace in varchar2 default NULL,
34 X_index_tablespace in varchar2 default NULL,
35 X_overwrite in boolean default FALSE);
36
37 procedure clone_schema(X_source_schema in varchar2,
38 X_clone_schema in varchar2,
39 X_degree in number);
40
41 procedure sync_schema(X_source_schema in varchar2,
42 X_clone_schema in varchar2,
43 X_degree in number);
44
45 procedure merge_schema(X_source_schema in varchar2,
46 X_clone_schema in varchar2,
47 X_degree in number);
48
49 procedure clean_up(X_source_schema in varchar2,
50 X_clone_schema in varchar2,
51 X_spec_schema in varchar2,
52 X_degree in number default null,
53 X_cleanup_clone in boolean default FALSE,
54 X_cleanup_spec in boolean default FALSE);
55
56 procedure get_status(X_source_schema in varchar2,
57 X_clone_schema in varchar2,
58 X_clone_phase out NOCOPY varchar2,
59 X_clone_status out NOCOPY varchar2);
60
61 procedure is_phase_complete(X_source_schema in varchar2,
62 X_clone_schema in varchar2,
63 X_phase_name in varchar2,
64 X_complete_flag out NOCOPY varchar2);
65
66 procedure validate_schemas(X_source_schema in varchar2,
67 X_clone_schema in varchar2,
68 X_spec_schema in varchar2);
69
70 procedure create_schema(X_schema_un in varchar2,
71 X_schema_pw in varchar2,
72 X_tablespace in varchar2);
73
74 procedure repoint_synonyms(X_source_schema in varchar2,
75 X_clone_schema in varchar2,
76 X_spec_schema in varchar2);
77
78 procedure cleanup_chkfile_info(X_apps_schema in varchar2);
79
80 procedure cleanup_spec_schema(X_spec_schema in varchar2);
81
82 procedure cleanup_clone_schema(X_source_schema in varchar2,
83 X_clone_schema in varchar2,
84 X_force_flag in boolean,
85 X_threads in number);
86
87
88 end;