In this case, she will be flashing back an existing table.
After clicking Next, she knows the precise time of day at which the table was valid, so she
specifies a time about ten minutes before the delete operation on the screen in Figure 7-8. In
addition, you can specify a restore point or SCN for the recovery operation if you don??™t know
the time of day.
In Figure 7-9, HR is selecting the table to flash back (in this case, HR.EMPLOYEES).
FIGURE 7-7 EM Database Control Backup/Recovery page
230 Oracle Database 11g DBA Handbook
FIGURE 7-8 Specifying the time frame for table recovery operation
FIGURE 7-9 Specifying the table name for table recovery operation
Chapter 7: Managing Transactions with Undo Tablespaces 231
FIGURE 7-10 Specifying the dependency options for table recovery operation
FIGURE 7-11 Reviewing table recovery operation actions
EM Database Control identifies any dependencies, such as foreign key constraints, and alerts
the HR user in Figure 7-10. Unless there is a good reason to break any parent/child relationships
between the tables, leave the default option, Cascade, selected.
In Figure 7-11, the HR user can take one more look at the options she has selected.
232 Oracle Database 11g DBA Handbook
In addition, as with most EM Database Control screens, she can review the SQL commands
generated:
FLASHBACK TABLE HR.EMPLOYEES, HR.JOBS, HR.DEPARTMENTS TO TIMESTAMP
to_timestamp('2007-08-05 20:10:47', 'YYYY-MM-DD HH24:MI:SS')
Clicking Submit runs the command.
Pages:
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392