Databases Reference
In-Depth Information
Dropping Restore Points
Problem
You want to drop a specific restore point.
Solution
To drop a restore point named rp2, whether normal or guaranteed, simply execute the following SQL statement:
SQL> drop restore point rp2;
Restore point dropped.
To list the restore points defined in the database, use Recipe 13-11.
How It Works
Normal restore points are merely pointers to the SCNs at the time they were defined. They do not consume any space.
Guaranteed restore points mark the flashback logs necessary to enable flashback to a specific point in time, and those
flashback logs do take up space. When you drop a guaranteed restore point, you will see an immediate increase in the
available space in the fast recovery area. To check the available space in the fast recovery area, refer to Recipe 3-4.
Recovering a Dropped Table
Problem
You accidentally dropped a table that should not have been dropped. You want to reinstate the table without doing a
database recovery.
Solution
If you dropped the table just moments ago, it is not actually dropped; it is placed in the recycle bin. Assume that you
dropped the table ACCOUNTS and want to revive it. You can resurrect that table from the recycle bin by following
these steps:
1.
Log on to the database as the table owner.
2.
Check whether the table exists in the recycle bin. Issue the SQL*Plus command show
recyclebin:
SQL> show recyclebin
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST BIN$xmtCqONCcZjgQ4CohAoD7Q==$0 TABLE 2012-08-04:01:53:19
