DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.SYS_FBA_FA

Object Details
Object Name: SYS_FBA_FA
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00234474
  1. ColumnFA#
Unique Key: SYS_C00234475
  1. ColumnFANAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00234474 NORMAL UNIQUE TablespaceSYSTEM ColumnFA#
SYS_C00234475 NORMAL UNIQUE TablespaceSYSTEM ColumnFANAME
Columns
Name Datatype Length Mandatory Comments
FANAME VARCHAR2 (255) Yes
FA# NUMBER
Yes
RETENTION NUMBER
Yes
CREATESCN NUMBER

PURGESCN NUMBER

FLAGS NUMBER
Yes
SPARE1 NUMBER

SPARE2 NUMBER

OWNERNAME VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FANAME
,      FA#
,      RETENTION
,      CREATESCN
,      PURGESCN
,      FLAGS
,      SPARE1
,      SPARE2
,      OWNERNAME
FROM SYS.SYS_FBA_FA;

Dependencies

[top of page]

SYS.SYS_FBA_FA does not reference any database object

SYS.SYS_FBA_FA is referenced by following:

SchemaSYS
ViewDBA_FLASHBACK_ARCHIVE
ViewDBA_FLASHBACK_ARCHIVE_TABLES
ViewDBA_FLASHBACK_ARCHIVE_TS
ViewKU$_FBA_VIEW
ViewUSER_FLASHBACK_ARCHIVE
ViewUSER_FLASHBACK_ARCHIVE_TABLES