On the Tablespace page, select the
tablespace to be reorganized (XPORT in this case), choose Reorganize in the Actions drop-down
box, and then click Go, as shown in Figure 4-10.
In Figure 4-11, on the Reorganize Objects page, you confirm that you are reorganizing the
XPORT tablespace and then click Next.
FIGURE 4-9 Viewing XPORT tablespace after adding a datafile
86 Oracle Database 11g DBA Handbook
FIGURE 4-10 Tablespace: Reorganize
FIGURE 4-11 Reorganize Objects: Objects
Chapter 4: Physical Database Layouts and Storage Management 87
The next page, as you can see in Figure 4-12, is where you set some of the parameters for the
reorganization, such as whether speed of the reorganization or the availability of the tablespace
is more important for this reorganization. In addition, you can leverage the tablespace rename
feature instead of using a scratch tablespace for a working area, potentially saving disk space
or the amount of time it will take for the reorganization. Other parameters on this page include
specifying parallel execution, index rebuilds without logging, and what level of statistics gathering
is required after the reorganization is complete.
Figure 4-13 shows the status of the script creation. The time it takes to generate the script is
roughly proportional to the number of objects in the tablespace.
A summary screen is presented with any warnings or errors encountered during script
generation, as you can see in Figure 4-14 on the Impact Report.
Pages:
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184