WARNING: This web is not used anymore. Please use PDBService.CoolTestFlashbackScripts instead!
 

Flashback scripts for Cool performance tests

21 Jun 2007

After successfully creating the scripts we spotted a big performance issue. For big tables the process takes way too much time. The conclusion is that we'll have to produce our own reverse database scripts...

20 Jun 2007

First of all, once the tables are created we should enable row movement on them and grant the flashback privilege to the user.

From doc :

Prerequisites

To flash back a table to an earlier SCN or timestamp, you must have either the FLASHBACK object privilege on the table or the FLASHBACK ANY TABLE system privilege. In addition, you must have the SELECT, INSERT, DELETE, and ALTER object privileges on the table.

Row movement must be enabled for all tables in the Flashback list unless you are flashing back the table TO BEFORE DROP. That operation is called a flashback drop operation, and it uses dropped data in the recyclebin rather than undo data. Please refer to row_movement_clause for information on enabling row movement.

To flash back a table to a restore point, you must have the SELECT ANY DICTIONARY or FLASHBACK ANY TABLE system privilege or the SELECT_CATALOG_ROLE role.

To flash back a table to before a DROP TABLE operation, you need only the privileges necessary to drop the table.

TO RESTORE POINT Clause

Specify a restore point to which you want to flash back the table. The restore point must already have been created.

See Also: CREATE RESTORE POINT for information on creating restore points

Note: Oracle strongly recommends that you run your database in automatic undo mode by setting the UNDO_MANAGEMENT initialization parameter to AUTO. In addition, set the UNDO_RETENTION initialization parameter to an interval large enough to include the oldest data you anticipate needing. For more information please refer to the documentation on the UNDO_MANAGEMENT and UNDO_RETENTION initialization parameters.

SQL> grant FLASHBACK ANY TABLE to USER;

Grant succeeded.

SQL> ALTER TABLE Table1 enable row movement;

Table altered.

SQL> CREATE RESTORE POINT good_data;

Restore point created.

SQL> FLASHBACK TABLE Table1;

Flashback complete.

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql CREATE_RESTORE_POINT.sql r1 manage 0.4 K 2007-06-21 - 10:21 RomainBasset  
Unknown file formatsql DROP_RESTORE_POINT.sql r1 manage 0.4 K 2007-06-21 - 10:21 RomainBasset  
Unknown file formatsql GENERATE_FLASHBACK_TABLE.sql r1 manage 0.9 K 2007-06-21 - 10:20 RomainBasset  
Unknown file formatsql GENERATE_ROW_MOVEMENT.sql r1 manage 0.7 K 2007-06-21 - 10:21 RomainBasset  
Edit | Attach | Watch | Print version | History: r9 | r7 < r6 < r5 < r4 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r5 - 2007-06-21 - RomainBasset
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback