79930
Rewinding a Table Using Oracle Flashback Table
Oracle Flashback Table enables you to rewind one or morę tables back to their contents at a previous timc without affccting other database objeets. Thus, you can recover from logical data corruptions such as table rows added or dclcted accidentally. Unlikc point-in-time necovery, the database remains available during the flashback operation.
For this example, you use Flashback Table on the employees table in the hr schcma.
Assume that an crroncous updatc shortly after October 23, 2005 at 15:30:00 has changed the 1 astname column for all employees to an empty string, and you must return the original lastname values to the table.
This section contains the fol łowi ng topics:
■Enabling Row Movcmcnt on a Table ■Performing a Flashback Table Operation
Wyszukiwarka
Podobne podstrony:
Recovering a Dropped Table Using Oracle Flashback Drop Oracle Flashback Drop cnablcs you to rcverscMonitoring Performance Using the Performance Hub The Performance Hub allows you to view all the perfBacking Up a Slave Using mysąidump Using mysąidump to create a copy of a database enables you to capRewinding a Database Using Oracle Flashback Database Unlikc thc othcr flashback fcatures, Oracle FlaEnabling Row Movement on a Table Bcforc you can use Flashback Table, you must ensure that row movemeChapter 3: Using Oracle VM VirtualBoxOverview To set up SAS University Edition: 1)  Deleting a Table If you no longcr nccd a table, then you can delete it using SQL Developer. When youf19 2 Oracle PowerBrowser (proffitt) - [Browser: Welcome to Netscape] l-k IX File Edit View NavigateCreative Doughcraft5 CHRISTMAS TABLE NAPKIN RINGS To make the head, roli a smali marble-size bali oAbout Online Redo Log Files Every Oracle database has a set of two or morę online redo log files. ThAbout Program Codę Stored in the Database Oracle Database offers the ability to storę program codę iAdding a New Table Constraint In this example, you add a table constraint to the purchase_orders tabPerforming User-Directed Recovery Uscr-Dircctcd Rccovcry cnablcs you to use flashback features and pdescribing events 1 UNIT 4 Describins festivals/events/ceremonies 1 H! Read the following table, the2 Field: Table: Sort: Append To: Criteria: or: Exprl:Round Table: FROM EXCELLENCE TO RECOGNITION • How to evaluate the scientifiowięcej podobnych podstron