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.V_$ARCHIVE_DEST

Object Details

Object Name:	V_$ARCHIVE_DEST
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
DEST_ID	NUMBER
DEST_NAME	VARCHAR2	(256)
STATUS	VARCHAR2	(9)
BINDING	VARCHAR2	(9)
NAME_SPACE	VARCHAR2	(7)
TARGET	VARCHAR2	(16)
ARCHIVER	VARCHAR2	(10)
SCHEDULE	VARCHAR2	(8)
DESTINATION	VARCHAR2	(256)
LOG_SEQUENCE	NUMBER
REOPEN_SECS	NUMBER
DELAY_MINS	NUMBER
MAX_CONNECTIONS	NUMBER
NET_TIMEOUT	NUMBER
PROCESS	VARCHAR2	(10)
REGISTER	VARCHAR2	(3)
FAIL_DATE	DATE
FAIL_SEQUENCE	NUMBER
FAIL_BLOCK	NUMBER
FAILURE_COUNT	NUMBER
MAX_FAILURE	NUMBER
ERROR	VARCHAR2	(256)
ALTERNATE	VARCHAR2	(256)
DEPENDENCY	VARCHAR2	(256)
REMOTE_TEMPLATE	VARCHAR2	(256)
QUOTA_SIZE	NUMBER
QUOTA_USED	NUMBER
MOUNTID	NUMBER
TRANSMIT_MODE	VARCHAR2	(12)
ASYNC_BLOCKS	NUMBER
AFFIRM	VARCHAR2	(3)
TYPE	VARCHAR2	(7)
VALID_NOW	VARCHAR2	(16)
VALID_TYPE	VARCHAR2	(15)
VALID_ROLE	VARCHAR2	(12)
DB_UNIQUE_NAME	VARCHAR2	(30)
VERIFY	VARCHAR2	(3)
COMPRESSION	VARCHAR2	(7)
APPLIED_SCN	NUMBER
CON_ID	NUMBER
ENCRYPTION	VARCHAR2	(7)

Query Text

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


SELECT DEST_ID
,      DEST_NAME
,      STATUS
,      BINDING
,      NAME_SPACE
,      TARGET
,      ARCHIVER
,      SCHEDULE
,      DESTINATION
,      LOG_SEQUENCE
,      REOPEN_SECS
,      DELAY_MINS
,      MAX_CONNECTIONS
,      NET_TIMEOUT
,      PROCESS
,      REGISTER
,      FAIL_DATE
,      FAIL_SEQUENCE
,      FAIL_BLOCK
,      FAILURE_COUNT
,      MAX_FAILURE
,      ERROR
,      ALTERNATE
,      DEPENDENCY
,      REMOTE_TEMPLATE
,      QUOTA_SIZE
,      QUOTA_USED
,      MOUNTID
,      TRANSMIT_MODE
,      ASYNC_BLOCKS
,      AFFIRM
,      TYPE
,      VALID_NOW
,      VALID_TYPE
,      VALID_ROLE
,      DB_UNIQUE_NAME
,      VERIFY
,      COMPRESSION
,      APPLIED_SCN
,      CON_ID
,      ENCRYPTION
FROM SYS.V_$ARCHIVE_DEST;

Dependencies

[top of page]

SYS.V_$ARCHIVE_DEST references the following:

SYS.V_$ARCHIVE_DEST is referenced by following:

PUBLIC: V$ARCHIVE_DEST