One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index is dropped but not a table it can't be restored from flashback but if a table is dropped that has an index you can restore the table and the index from flashback. The example below … Continue reading Information on flashback feature in 10g
Tag: 10g
Enabling Flashback Database
The following are the requirements for enabling Flashback Database: - Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation. - You must have a flash recovery area enabled, because flashback logs can only be stored in the flash recovery area. - For Real Application Clusters databases, … Continue reading Enabling Flashback Database
alexlima.com 