Once enabled, a user doesn??™t need any specific permissions to use the as of clause in a select
statement other than the SELECT permission on the table itself.
238 Oracle Database 11g DBA Handbook
The FLASHBACK_ARCHIVE_ADMINSTER privilege also includes adding and removing
tablespaces from an archive, dropping an archive, and performing an ad hoc purge of history data.
Managing Flashback Data Archives
You can easily add another tablespace to an existing archive; use the alter flashback archive
command like this to add the USERS3 tablespace to the FB_DFLT archive with a quota of 400MB:
SQL> alter flashback archive fb_dflt
2 add tablespace users3 quota 400m;
Flashback archive altered.
SQL>
You can purge archive data with the purge clause; in this example, you want to purge all rows
in the FB_DFLT archive before January 1, 2005:
SQL> alter flashback archive fb_dflt
2 purge before timestamp
3 to_timestamp('2005-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
Assigning a Table to a Flashback Data Archive
You assign a table to an archive either at table creation using the standard create table syntax
with the addition of the flashback archive clause, or later with the alter table command, as in
this example:
SQL> alter table hr.employees flashback archive fb_es;
Table altered.
Note that in the previous command that specified a specific archive for the HR.EMPLOYEES
table; if you did not specify an archive, Oracle assigns FB_DFLT.
Pages:
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401