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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
<HTML><HEAD><TITLE>Schema extraction, compare and search</TITLE></HEAD><BODY>
<H1>Schema extraction, compare and search</H1>
This tool is used to either extract a script to recreate database objects, compare database objects or search database objects.<P>
<IMG SRC=images/script.png><P>
<H2>Defining the operation</H2>
The first thing to select is if you want to <B>extract</B> script to recreate an object, <B>compare</B> or <B>search</B>. You choose
this by selecting one of the radio buttons to the left of the screen.<P>
Next you should indicate what kind of information you want included in the extract or compare. This is selected with the
checkboxes just to the right of the mode selection. Depending on the mode some options may be
disabled.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Include DDL</B></TD><TD VALIGN=top>
Include any database definition.</TD></TR>
<TR><TD VALIGN=top><B>
Include constraints</B></TD><TD VALIGN=top>
Extract constraint definitions from tables</TD></TR>
<TR><TD VALIGN=top><B>
Include indexes</B></TD><TD VALIGN=top>
Extract indexes for tables.</TD></TR>
<TR><TD VALIGN=top><B>
Include grants</B></TD><TD VALIGN=top>
Extract grants for database objects.</TD></TR>
<TR><TD VALIGN=top><B>
Include storage specification</B></TD><TD VALIGN=top>
Extract storage specifications for database objects.</TD></TR>
<TR><TD VALIGN=top><B>
Include parallel specification</B></TD><TD VALIGN=top>
Extract parallel specification for tables.</TD></TR>
<TR><TD VALIGN=top><B>
Include partition specification</B></TD><TD VALIGN=top>
Extract partition specification for tables.</TD></TR>
<TR><TD VALIGN=top><B>
Include code specification</B></TD><TD VALIGN=top>
Extract code for packages, procedures and functions.</TD></TR>
<TR><TD VALIGN=top><B>
Include comments</B></TD><TD VALIGN=top>
Extract comments for database objects.</TD></TR>
<TR><TD VALIGN=top><B>
Include content of tables</B></TD><TD VALIGN=top>
Extract the content of tables as well.</TD></TR>
<TR><TD VALIGN=top><B>
Generate prompts</B></TD><TD VALIGN=top>
Generate prompts in the extracted result indicating what the script is doing.</TD></TR>
<TR><TD VALIGN=top><B>
Generate header</B></TD><TD VALIGN=top>
Generate header of the script.</TD></TR>
<TR><TD VALIGN=top><B>
Generated schema</B></TD><TD VALIGN=top>
This specifies the schema to be used when extracting. If you select <B>Same</B>, the same
schema as the source database is used. If you select <B>None</B>, no schema is generated.
Specifying anything else will replace the source schema with the one entered here.
</TD></TR>
</TABLE>
<P>
If you are searching you also need to indicate what you are searching for in the bottom left of
the front page.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Containing any words</B></TD><TD VALIGN=top>
The object should contain at least one of the words in the line editor.
</TD></TR>
<TR><TD VALIGN=top><B>
Containing all words</B></TD><TD VALIGN=top>
The object should contain all of the words in the line editor.
</TD></TR>
<TR><TD VALIGN=top><B>
Exact match</B></TD><TD VALIGN=top>
The object should contain the exact string as in the line editor include whitespaces.
</TD></TR>
<TR><TD VALIGN=top><B>
RegExp</B></TD><TD VALIGN=top>
The object should contain at least one of the words in the line editor. The dialect of RegExp:s
is the ones in the version of Qt that TOra is compiled against.
For more information on regular expressions check out
<A HREF=http://doc.trolltech.com/qregexp.html>http://doc.trolltech.com/qregexp.html</A>, if you are using Qt 3.0
or later you have a more advanced form of regular expressions.
</TD></TR>
</TABLE>
<P>
The next thing you need to do is to specify which objects you want to extract or compare. If you
extract you only need to specify the source, if comparing destination objects are also needed.<P>
Selecting or deselecting an item in this list will select all it's child items.<P>
If you specify the <B>extract</B> mode you can also indicate a way to resize generated
storage specifications. This could be useful to make a database have only a few standard
storage specifications making the database less prone to fragmentation.<P>
<IMG SRC=images/resize.png><P>
You have three modes to specify how resizing should work. First there is <B>Don't resize</B>
which means leave the same as the original. Then there is <B>Auto resize</B> which should
work for pretty much everyone. In this a resize specification for each order of magnitude of
size is given a specific storage specification. And last is the <B>Custom resize</B> mode in
which you specify how to transform the storage specifications to new values.<P>
When you specify a custom resize you add items to the list with a <B>limit</B> size,
<B>initial</B> size and <B>next</B> size. The sizes are used in the following way. When TOra
is to determine the storage clause of an object it will take the <B>initial</B> and <B>next</B>
sizes of the row in this list with the lowest <B>limit</B> size still higher than the current
size of the object. If no row is found the one with the highest <B>limit</B> is used.<P>
<H2>Reading the result</H2>
If you <b>extract</B> the result is available under the <B>Result</B> tag of the dialog in the
form of a worksheet tool where you can either start executing it or save it to a file. If you
are comparing objects you will get the result under the <B>Difference</B> tab. The tab will
look something like this.<P>
<IMG SRC=images/difference.png><P>
On the left is a pane containing objects only available in the source database. On the right
is a pane containing the objects only available in the destination database.<P>
Only the items in the lists that have checks on them are actually dropped or created, the
other items only need to be added to lead the list tree to the items that are actually dropped
or created.<P>
</BODY>
</HTML>
|