SQL>
You cannot specify more than one tablespace in the create flashback archive command; you
must use the alter flashback archive command to add a tablespace, as you??™ll see later in this chapter,
in the section ???Managing Flashback Data Archives.???
Using Flashback Data Archive Data Dictionary Views
Two new data dictionary views support Flashback Data Archives: DBA_FLASHBACK_ARCHIVE
and DBA_FLASHBACK_ARCHIVE_TS. DBA_FLASHBACK_ARCHIVE lists the archives, and DBA_
FLASHBACK_ARCHIVE_TS displays the tablespace-to-archive mapping:
SQL> select flashback_archive_name, flashback_archive#,
2 retention_in_days, status
3 from dba_flashback_archive;
FLASHBACK_AR FLASHBACK_ARCHIVE# RETENTION_IN_DAYS STATUS
------------ ------------------ ----------------- -------
FB_ES 1 3650
FB_FI 2 2555
FB_DFLT 3 730 DEFAULT
SQL> select * from dba_flashback_archive_ts;
FLASHBACK_AR FLASHBACK_ARCHIVE# TABLESPACE QUOTA_IN_M
------------ ------------------ ---------- ----------
FB_ES 1 FBDA1
FB_FI 2 FBDA1 500
FB_DFLT 3 USERS4 250
SQL>
The view DBA_FLASHBACK_ARCHIVE_TABLES tracks the tables enabled for flashback
archiving. I??™ll show you the contents of this view later in this chapter after enabling a table for
flashback archiving.
Assigning Flashback Data Archive Permissions
A user must have the FLASHBACK ARCHIVE ADMINISTER system privilege to create or modify
Flashback Data Archives, and the FLASHBACK ARCHIVE object privilege to enable tracking on a
table.
Pages:
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400