6.3. Using EM to Perform Flashback Dropped Tables

The Flashback Dropped Tables capability can be performed with Enterprise Manager (EM). The available Flashback Dropped Tables can be identified by schema in the Maintenance Recovery Dropped Objects screen. The targeted database objects can be identified to be Flashback Dropped.

The process to Flashback Drop leads you first through an object identification screen. Next, you are allowed to rename the object before you Flashback Drop the object. The last screen allows you to review your actions before the object is finally rebuilt.

Let's walk through this process in more detail:

  1. Log in to EM as a SYSDBA-enabled user.



  2. You will be redirected to the EM Home page, illustrated in the next two graphics.



  3. Select the Maintenance Tab.



  4. Once in the Maintenance menu, select the Perform Recovery option. You will be directed to the Perform Recovery: Type screen.



  5. Select the Tables option from the Object Type drop-down list box.



  6. On the second Perform Recovery: Type screen, select the Flashback Dropped Tables radio button and click Next.

  7. The Perform Recovery: Dropped Objects Selection screen appears. Click the Flashlight icon, select the schema owner Test, and click the Go button.



  8. This will display all the tables that can be Flashback Drop recovered. In this example, it is the table T2. Select the T2 check box and click the Next button to proceed with the Flashback Drop recovery.



  9. The Perform Recovery: Rename screen appears. At this point, you can choose to rename the table that you have selected to Flashback Drop recover. In this example, we will not rename the table. Click the Next button.



  10. The Perform Recovery: Review screen appears, which shows the tables you have selected, and the names of the tables if you have changed their names. Click the Submit button to process the Flashback Drop recovery.



As you can see, EM performs the Flashback Drop in a straightforward manner. The standard recovery screen is selected initially. Choosing the Table option in the recovery screen determines that the Flashback Drop recovery will be initiated. By clicking the Show SQL button, you can see that the SQL command FLASHBACK DROP table_name TO BEFORE DROP is executed.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset