Oracle: DBA_FLASHBACK_ARCHIVE_TABLES

select
   owner_name,
   table_name,
   archive_table_name,
   flashback_archive_name,
   status
from
   dba_flashback_archive_tables;