eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_FLASHBACK_ARCHIVE

Object Details

Object Name:	USER_FLASHBACK_ARCHIVE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of the flashback archives available to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER_NAME	VARCHAR2	(30)		Name of the creator of the flashback archive
FLASHBACK_ARCHIVE_NAME	VARCHAR2	(255)	Yes	Name of the flashback archive
FLASHBACK_ARCHIVE#	NUMBER		Yes	Number of the flashback archive
RETENTION_IN_DAYS	NUMBER		Yes	Maximum duration in days for which data is retained in the flashback archive
CREATE_TIME	TIMESTAMP(9)	(20)		Time at which the flashback archive was created
LAST_PURGE_TIME	TIMESTAMP(9)	(20)		Time at which the data in the flashback archive was last purged by the system
STATUS	VARCHAR2	(7)		Indicates whether the flashback archive is a default flashback archive for the system

Query Text

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


SELECT OWNER_NAME
,      FLASHBACK_ARCHIVE_NAME
,      FLASHBACK_ARCHIVE#
,      RETENTION_IN_DAYS
,      CREATE_TIME
,      LAST_PURGE_TIME
,      STATUS
FROM SYS.USER_FLASHBACK_ARCHIVE;

Dependencies

[top of page]

SYS.USER_FLASHBACK_ARCHIVE references the following:

SYS: SCN_TO_TIMESTAMP; SYS_FBA_FA; SYS_FBA_USERS; USER$

SYS.USER_FLASHBACK_ARCHIVE is referenced by following:

PUBLIC: USER_FLASHBACK_ARCHIVE