Laying the Groundwork

The heading of this section sounds much more important than it really is, and although we don’t mean to disappoint you, Flashback Technology is all about recovery from user error. In other words, recovering from that “delete * from my_ very_important_table” without incurring addition data loss and downtime from a point-in-time recovery. That said, you do need to have a basic schema in place to follow along with this chapter. The schema (let’s consider it a subschema) involves two tables in a parent-child relationship from our LunarTrax database. The parent table is the space_ship table with the child table being the space_ship_maint table. Here is the schema definition and sample data: