-
Notifications
You must be signed in to change notification settings - Fork 187
Expand file tree
/
Copy pathut_i_install.sql
More file actions
68 lines (48 loc) · 1.27 KB
/
ut_i_install.sql
File metadata and controls
68 lines (48 loc) · 1.27 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
SET TERMOUT OFF
SET ECHO OFF
SET VERIFY OFF
SET FEEDBACK OFF
SET TTITLE OFF
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED
SET DEFINE ON
SPOOL ut_i_install.log
----------------------------------------------------TABLES
SET TERMOUT ON
PROMPT &line1
PROMPT CREATING &UT TABLES
PROMPT &line1
DEFINE prompt_text='Creating &UT tables '
@@ut_i_tables
----------------------------------------------------SEQUENCES
SET TERMOUT ON
PROMPT &line1
PROMPT CREATING &UT SEQUENCES
PROMPT &line1
DEFINE prompt_text='Creating &UT sequence '
@@ut_i_sequences
----------------------------------------------------VIEWS
SET TERMOUT ON
PROMPT &line1
PROMPT CREATING &UT VIEWS
PROMPT &line1
DEFINE prompt_text='Creating &UT view '
@@ut_i_views
----------------------------------------------------PACKAGE HEADERS
SET TERMOUT ON
PROMPT &line1
PROMPT CREATING &UT PACKAGE HEADERS
PROMPT &line1
DEFINE prompt_text='Creating &UT package specification '
@@ut_i_packages
----------------------------------------------------PACKAGE BODIES
SET TERMOUT ON
PROMPT &line1
PROMPT CREATING &UT PACKAGE BODIES
PROMPT &line1
DEFINE prompt_text='Creating &UT package body '
@@ut_i_packages_b
SET TERMOUT OFF
SPOOL OFF
----------------------------------------------------GENERIC SCRIPTS
@@ut_i_synonyms
@@ut_i_grants