FIGURE 4-12 Reorganize Objects: Options
88 Oracle Database 11g DBA Handbook
FIGURE 4-13 Processing: Generating Reorganization Script
FIGURE 4-14 Reorganize Objects: Impact Report
After clicking Next, you see the Schedule page, as shown in Figure 4-15. In this scenario, go
ahead and specify host credentials for the server, but we will not submit the job at the end of the
wizard because we need to make one edit to the script.
Clicking Next, we arrive at the Review page in Figure 4-16. An excerpt of the generated script
is presented in the text box. Instead of submitting the job, you will click Save Full Script to make
one minor change to the script before you run it.
In Figure 4-17, you specify the location where you want to save the script.
Chapter 4: Physical Database Layouts and Storage Management 89
FIGURE 4-15 Reorganize Objects: Schedule
FIGURE 4-16 Reorganize Objects: Review
90 Oracle Database 11g DBA Handbook
When you edit the full script, locate the execute immediate command where the tablespace
is created:
EXECUTE IMMEDIATE 'CREATE SMALLFILE TABLESPACE "XPORT_REORG0"
DATAFILE '/u02/oradata/xport_reorg0.dbf' SIZE 200M REUSE,
''/u04/oradata/xport2_reorg0.dbf'' SIZE 100M REUSE
LOGGING EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO';
Because we want to drop a datafile, we want to remove the highlighted datafile clause in the
script and then either change the location of the second datafile or re-create the first datafile with
a larger size.
Pages:
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185