[Home] [Help]
PACKAGE: SYS.DBMS_PLUGTSP
Source
1 PACKAGE dbms_plugtsp IS
2
3 --++
4 -- Definition: This procedure will finish things up after objects have been
5 -- created. Patchup table metadata after table has been created
6 -- at the import site. This procedure is called by import
7 --
8 -- Inputs: schemaName - schema name
9 -- tableName - table name
10 -- mdClob - data pump's metadata
11 -- expSrvrEndian - export endian
12 -- impSrvrEndian - import endian
13 --
14 -- Outputs: None
15 --++
16 PROCEDURE patchTableMetadata(
17 schemaName IN VARCHAR2,
18 tableName IN VARCHAR2,
19 mdClob IN CLOB,
20 expSrvrEndian IN BINARY_INTEGER,
21 impSrvrEndian IN BINARY_INTEGER);
22
23 --++
24 -- Description: This procedure wil fixup various things that get lost across
25 -- transport due to no relevant syntax (i.e. options/versions
26 -- based on compatibility rather than explicit syntax). This
27 -- is called during TTS import.
28 --
29 -- Inputs: str1
30 -- str2
31 -- str3
32 -- str4
33 -- str5
34 -- str6
35 -- str7
36 -- bin1
37 --
38 -- Outputs: None
39 --++
40 PROCEDURE patchDictionary(
41 str1 IN VARCHAR2,
42 str2 IN VARCHAR2,
43 str3 IN VARCHAR2,
44 str4 IN VARCHAR2,
45 str5 IN VARCHAR2,
46 str6 IN VARCHAR2,
47 str7 IN VARCHAR2,
48 bin1 IN BINARY_INTEGER);
49
50 PROCEDURE patchLobProp(schemaName IN VARCHAR2, -- schema name
51 tableName IN VARCHAR2); -- table name
52 -- patchup lob property after table has been created
53 -- at the import site
54 -- This procedure is called by import for pre 10i tts dump files
55
56 /*******************************************************************
57 ** Possible Exceptions **
58 *******************************************************************/
59
60 -- These were copied from the dbms_plugts package which is not public-execute
61
62 ts_not_found EXCEPTION;
63 PRAGMA exception_init (ts_not_found, -29304);
64 ts_not_found_num NUMBER := -29304;
65
66 ts_not_read_only EXCEPTION;
67 PRAGMA exception_init (ts_not_read_only, -29335);
68 ts_not_read_only_num NUMBER := -29335;
69
70 internal_error EXCEPTION;
71 PRAGMA exception_init (internal_error, -29336);
72 internal_error_num NUMBER := -29336;
73
74 datafile_not_ready EXCEPTION;
75 PRAGMA exception_init (datafile_not_ready, -29338);
76 datafile_not_ready_num NUMBER := -29338;
77
78 blocksize_mismatch EXCEPTION;
79 PRAGMA exception_init (blocksize_mismatch, -29339);
80 blocksize_mismatch_num NUMBER := -29339;
81
82 exportfile_corrupted EXCEPTION;
83 PRAGMA exception_init (exportfile_corrupted, -29340);
84 exportfile_corrupted_num NUMBER := -29340;
85
86 not_self_contained EXCEPTION;
87 PRAGMA exception_init (not_self_contained, -29341);
88 not_self_contained_num NUMBER := -29341;
89
90 user_not_found EXCEPTION;
91 PRAGMA exception_init (user_not_found, -29342);
92 user_not_found_num NUMBER := -29342;
93
94 mapped_user_not_found EXCEPTION;
95 PRAGMA exception_init (mapped_user_not_found, -29343);
96 mapped_user_not_found_num NUMBER := -29343;
97
98 user_not_in_list EXCEPTION;
99 PRAGMA exception_init (user_not_in_list, -29344);
100 user_not_in_list_num NUMBER := -29344;
101
102 different_char_set EXCEPTION;
103 PRAGMA exception_init (different_char_set, -29345);
104 different_char_set_num NUMBER := -29345;
105
106 invalid_ts_list EXCEPTION;
107 PRAGMA exception_init (invalid_ts_list, -29346);
108 invalid_ts_list_num NUMBER := -29346;
109
110 ts_not_in_list EXCEPTION;
111 PRAGMA exception_init (ts_not_in_list, -29347);
112 ts_not_in_list_num NUMBER := -29347;
113
114 datafiles_missing EXCEPTION;
115 PRAGMA exception_init (datafiles_missing, -29348);
116 datafiles_missing_num NUMBER := -29348;
117
118 ts_name_conflict EXCEPTION;
119 PRAGMA exception_init (ts_name_conflict, -29349);
120 ts_name_conflict_num NUMBER := -29349;
121
122 sys_or_tmp_ts EXCEPTION;
123 PRAGMA exception_init (sys_or_tmp_ts, -29351);
124 sys_or_tmp_ts_num NUMBER := -29351;
125
126 ts_list_overflow EXCEPTION;
127 PRAGMA exception_init (ts_list_overflow, -29353);
128 ts_list_overflow_num NUMBER := -29353;
129
130 ts_failure_list EXCEPTION;
131 PRAGMA exception_init (ts_failure_list, -39185);
132 ts_failure_list_num NUMBER := -39185;
133
134 ts_list_empty EXCEPTION;
135 PRAGMA exception_init (ts_list_empty, -39186);
136 ts_list_empty_num NUMBER := -39186;
137
138 not_self_contained_list EXCEPTION;
139 PRAGMA exception_init (not_self_contained_list, -39187);
140 not_self_contained_list_num NUMBER := -39187;
141
142 /*********************************************
143 ** C callout definitions **
144 *********************************************/
145 -- patch table metadata
146 PROCEDURE kcp_ptmd(
147 schemaName IN VARCHAR2, -- schema name
148 tableName IN VARCHAR2, -- table name
149 mdClob IN CLOB, -- data pump's metadata
150 expSrvrEndian IN BINARY_INTEGER, -- export server endian
151 impSrvrEndian IN BINARY_INTEGER); -- import server endian
152
153 -- patch dictionary
154 PROCEDURE kcp_pd(
155 str1 IN VARCHAR2, -- schema name
156 str2 IN VARCHAR2,
157 str3 IN VARCHAR2,
158 str4 IN VARCHAR2,
159 str5 IN VARCHAR2,
160 str6 IN VARCHAR2,
161 str7 IN VARCHAR2,
162 bin1 IN BINARY_INTEGER); -- Bitmap, etc.
163
164 END dbms_plugtsp;