Dropping a Table

For the purpose of learning about Flashback Drop, you will create a new table named reg_hist and then drop it. The database places the table in the recycle bin so that it can be retrieved with the Flashback Drop feature.

To create and then drop a table:

1. On the Database Home page, click Schema to display the Schema subpage.

2. Click Tables.

   The Tables page appears.

3. Enter hr in the Schema field and regions in the Object Name field. Click Go.

   The schema and table are listed in the table at the bottom of the page.

4. In the Actions list, select Create Like and click Go.

   The General subpage of the Create Table page appears.

5. Complete the following steps:

   1. In the Name field, enter reg_hist.

   2. Deselect Not Null for the REGION_ID column.

   3. Click Constraints to open the Constraints subpage.

      The Constraints subpage appears.

   4. Select each constraint and click Delete.

   5. Click OK to create the table.

      A confirmation message appears.

6. In the Object Name field, enter reg_hist and click Go.

   The Tables page displays information about this table.

7. Click Delete with Options to delete the table.

   The Delete With Options page appears.

8. Select Delete the table definition, all its data, and dependent objects (DROP), and then click Yes.

   A message confirms that the table was deleted.