[Home] [Help] [Dependency Information]
Object Name: | GV_$ARCHIVE_DEST |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, 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.GV_$ARCHIVE_DEST;
|
|
|