You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for flashback table


1 to 20 of 13687 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

FLASHBACK TABLE

FLASHBACK TABLEPurpose Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of … cannot roll back a FLASHBACK TABLE statement. However, you can issue another FLASHBACK TABLE … current SCN before issuing a FLASHBACK TABLE

SQL Reference, 10g Release 1 (10.1)

FLASHBACK TABLE

Restrictions on Flashing Back TablesFlashback Table operations are not valid for the following type objects: tables that are part of a … enabled triggers defined on table during the Flashback Table operation and then reenables them after … the Flashback Table operation is complete. Specify ENABLE TRIGGERS

Administrator's Guide, 10g Release 1 (10.1)

10 Managing the Undo Tablespace

Flashback TableThe FLASHBACK TABLE statement lets users recover a table to a previous point in time. It provides a … enough to cover the period specified in the FLASHBACK TABLE statement. See Also: "Recovering Tables … Using the Flashback Table Feature" for more information about the

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Returning a Table to a Past State: Flashback TableOracle Flashback Table lets you revert one or more tables back to their contents at a previous time … table. Flashback Table lets you return tables you select to their state at a past point in time, without … available during the operation. For this example, we will perform Flashback

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

3 Oracle Database High Availability Features

3.7.4 Oracle Flashback TableOracle Flashback Table recovers a table to its state at a previous point in time. You can restore … table data while the database is online, undoing changes to only the specified table.

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Auditing Table Changes Using Flashback Transaction QueryTable feature, described in "Recovering Tables Using the Flashback Table Feature", to restore the … Note: You must be using automatic undo management to use the Flashback Transaction Query feature … database for the Flashback Transaction Query feature, see "Monitoring the Undo Tablespace". You may

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Recovering Tables Using the Flashback Table FeatureNote: You must be using automatic undo management to use the Flashback Table feature. It is based … for the Flashback Table feature, see "Monitoring the Undo Tablespace". The FLASHBACK TABLE … many cases, this Flashback Table feature alleviates the need

Backup and Recovery Advanced User's Guide, 10g Release 1 (10.1)

9 Flashback Technology: Recovering from Logical Corruptions

Oracle Flashback Table: Returning Individual Tables to Past StatesOracle Flashback Table provides the DBA the ability to recover a table or set of tables to a … offline. In many cases, Flashback Table eliminates the need to perform more complicated point-in-time … recovery operations. Flashback Table restores tables while automatically

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Recovering Dropped Tables: Flashback DropOracle Flashback Drop lets you reverse the effects of dropping a table, returning the dropped table … , either explicitly or because space is needed for new database objects. As with Flashback Table … , Flashback Drop can be used while the rest of your database remains open, and without

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

10 Detailed Recovery Steps

Flashback Feature DescriptionTable 10-7 Summary of Flashback Features Flashback Feature Description Flashback Query Flashback … are propagated to physical standby databases. Flashback Table Flashback Table enables you to quickly … . Note: Changes are propagated

Backup and Recovery Advanced User's Guide, 10g Release 1 (10.1)

9 Flashback Technology: Recovering from Logical Corruptions

Oracle Flashback Technology: Overviewsingle transaction, or by all the transactions during a period of time. Oracle Flashback Table returns a … online, undoing changes only to the specified table. Oracle Flashback Drop reverses the effects of a … DROP TABLE statement. Oracle Flashback Database provides a more efficient

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

15 Using Flashback Features

15 Using Flashback Featuresadministration tasks, such as Oracle Flashback Database and Oracle Flashback Table Oracle Database SQL … This chapter discusses the following flashback topics: Overview of Flashback Features Database … Administration Tasks Before Using Flashback Features Using Flashback

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

15 Using Flashback Features

Using Flashback Version Querythe time interval. The Flashback Version Query returns a table with a row for each version of the row … and how a particular change (perhaps erroneous) occurred to your database. Table 15-1   Flashback … identify the past target time for a Flashback Table or Flashback

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

15 Using Flashback Features

Using Flashback Transaction QueryFlashback Table feature to restore an entire table, rather than individual rows As an example, the … A Flashback Transaction Query is a query on the view FLASHBACK_TRANSACTION_QUERY. You use a … Flashback Transaction Query to obtain transaction information, including SQL code that you can use to undo

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

15 Using Flashback Features

Database Administration Featuresdatabase is on line, undoing changes to only the specified table. Oracle Flashback Drop - recover a … dropped table. This reverses the effects of a DROP TABLE statement. Oracle Flashback Database … Database, Flashback Table, and Flashback Drop are primarily

Concepts, 10g Release 1 (10.1)

15 Backup and Recovery

When to Use Oracle FlashbackFlashback Table is a push button solution to restore the contents of a table to a given point in … fast alternative to performing incomplete database recovery. Flashback Table uses information in the … terms of ease of use, availability, and faster restoration. Flashback Database and

Concepts, 10g Release 1 (10.1)

15 Backup and Recovery

Recovery Using Oracle Flashback TechnologyFlashback Database and Flashback Table let you quickly recover to a previous time. This section … Table See Also: "Overview of Oracle Flashback Features" for an overview of all Oracle Flashback features … Overview of Oracle Flashback Table

Administrator's Guide, 10g Release 1 (10.1)

10 Managing the Undo Tablespace

Flashback Features and Undo SpaceQuery Flashback Versions Query Flashback Transaction Query Flashback Table The retention period for … features are part of the overall flashback strategy incorporated into the database and include: Flashback … undo information is an important factor for the successful execution of Flashback

New Features, 10g Release 1 (10.1)

1 Oracle Database 10 g, Release 1 New Features

Recovering from Human Error with Flashback Technologyturn results in much less downtime following data corruption or human error. Oracle Flashback Table … This feature introduces the FLASHBACK TABLE statement in SQL, which enables you to quickly recover a … table to a point in time in the past without restoring a backup. Oracle Flashback

Backup and Recovery Advanced User's Guide, 10g Release 1 (10.1)

9 Flashback Technology: Recovering from Logical Corruptions

9 Flashback Technology: Recovering from Logical Corruptions: Overview Oracle Flashback Query: Recovering at the Row Level Oracle Flashback Table: Returning Individual … Tables to Past States Oracle Flashback Drop: Undo a DROP TABLE Operation Oracle Flashback Database … This chapter describes how to use the flashback features