ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_REPPROP: Propagation information about
replicated objects
iSelfSchooling-SQL> desc ALL_REPPROP;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(16)
DBLINK
NOT NULL VARCHAR2(128)
HOW
VARCHAR2(13)
PROPAGATE_COMMENT
VARCHAR2(80)
ALL_REPRESOLUTION: Description of all conflict resolutions
for replicated tables which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPRESOLUTION;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
SEQUENCE_NO
NOT NULL NUMBER
METHOD_NAME
NOT NULL VARCHAR2(80)
FUNCTION_NAME
NOT NULL VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
RESOLUTION_COMMENT
VARCHAR2(80)
ALL_REPRESOLUTION_METHOD: All conflict resolution methods
accessible to the user
iSelfSchooling-SQL> desc ALL_REPRESOLUTION_METHOD;
Name
Null?
Type
----------------------------- -------- --------------------
CONFLICT_TYPE
VARCHAR2(10)
METHOD_NAME
NOT NULL VARCHAR2(80)
ALL_REPRESOLUTION_STATISTICS: Statistics for conflict resolutions for
replicated tables which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPRESOLUTION_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(80)
FUNCTION_NAME
VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
RESOLVED_DATE
NOT NULL DATE
PRIMARY_KEY_VALUE
NOT NULL VARCHAR2(2000)
ALL_REPRESOL_STATS_CONTROL: Information about statistics collection
for conflict resolutions for replicated tables which are accessible to the
user
iSelfSchooling-SQL> desc ALL_REPRESOL_STATS_CONTROL;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
VARCHAR2(9)
STATUS_UPDATE_DATE
NOT NULL DATE
PURGED_DATE
DATE
LAST_PURGE_START_DATE
DATE
LAST_PURGE_END_DATE
DATE
ALL_REPSCHEMA: N-way replication information
iSelfSchooling-SQL> desc ALL_REPSCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
GNAME
NOT NULL VARCHAR2(30)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
ALL_REPSITES: N-way replication information
iSelfSchooling-SQL> desc ALL_REPSITES;
Name
Null? Type
----------------------------- -------- --------------------
GNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
ALL_REWRITE_EQUIVALENCES: Description of all rewrite equivalence
accessible to the user
iSelfSchooling-SQL> desc ALL_REWRITE_EQUIVALENCES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
SOURCE_STMT
CLOB
DESTINATION_STMT
CLOB
REWRITE_MODE
VARCHAR2(10)
ALL_RULES: Rules seen by the user
iSelfSchooling-SQL> desc ALL_RULES;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_CONDITION
CLOB
RULE_EVALUATION_CONTEXT_OWNER VARCHAR2(30)
RULE_EVALUATION_CONTEXT_NAME VARCHAR2(30)
RULE_ACTION_CONTEXT
RE$NV_LIST
RULE_COMMENT
VARCHAR2(4000)
ALL_RULESETS: Rule sets seen by the user: maintained
for backward compatibility
iSelfSchooling-SQL> desc ALL_RULESETS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
RULESET_NAME
NOT NULL VARCHAR2(30)
RULESET_STORAGE_TABLE
VARCHAR2
BASE_TABLE
VARCHAR2(61)
RULESET_COMMENT
VARCHAR2(4000)
ALL_RULE_SETS: Rule sets seen by the user
iSelfSchooling-SQL> desc ALL_RULE_SETS;
Name
Null? Type
----------------------------- -------- --------------------
RULE_SET_OWNER
NOT NULL VARCHAR2(30)
RULE_SET_NAME
NOT NULL VARCHAR2(30)
RULE_SET_EVAL_CONTEXT_OWNER VARCHAR2(30)
RULE_SET_EVAL_CONTEXT_NAME VARCHAR2(30)
RULE_SET_COMMENT
VARCHAR2(4000)
ALL_RULE_SET_RULES: Rules in all rule sets seen by the user
iSelfSchooling-SQL> desc ALL_RULE_SET_RULES;
Name
Null? Type
----------------------------- -------- --------------------
RULE_SET_OWNER
NOT NULL VARCHAR2(30)
RULE_SET_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_SET_RULE_ENABLED
VARCHAR2(8)
RULE_SET_RULE_EVAL_CTX_OWNER VARCHAR2(30)
RULE_SET_RULE_EVAL_CTX_NAME VARCHAR2(30)
RULE_SET_RULE_COMMENT
VARCHAR2(4000)
ALL_SCHEDULER_CHAINS: All scheduler chains in the database
visible to current user
iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAINS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CHAIN_NAME
NOT NULL VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
NUMBER_OF_RULES
NUMBER
NUMBER_OF_STEPS
NUMBER
ENABLED
VARCHAR2(5)
EVALUATION_INTERVAL
INTERVAL DAY(3) TO
SECOND(0)
USER_RULE_SET
VARCHAR2(5)
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_CHAIN_RULES: All rules from scheduler chains visible
to the current user
iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_RULES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CHAIN_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
CONDITION
VARCHAR2(4000)
ACTION
VARCHAR2(4000)
COMMENTS
VARCHAR2(4000)
ALL_SCHEDULER_CHAIN_STEPS: All steps of scheduler chains visible
to the current user
iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_STEPS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CHAIN_NAME
NOT NULL VARCHAR2(30)
STEP_NAME
NOT NULL VARCHAR2(30)
PROGRAM_OWNER
VARCHAR2(98)
PROGRAM_NAME
VARCHAR2(98)
EVENT_SCHEDULE_OWNER
VARCHAR2(98)
EVENT_SCHEDULE_NAME
VARCHAR2(98)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
SKIP
VARCHAR2(5)
PAUSE
VARCHAR2(5)
RESTART_ON_RECOVERY
VARCHAR2(5)
STEP_TYPE
VARCHAR2(14)
TIMEOUT
INTERVAL DAY(3)TO SECOND(0)
ALL_SCHEDULER_GLOBAL_ATTRIBUTE: All scheduler global attributes
iSelfSchooling-SQL> desc ALL_SCHEDULER_GLOBAL_ATTRIBUTE;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE_NAME
NOT NULL VARCHAR2(30)
VALUE
VARCHAR2(128)
ALL_SCHEDULER_JOBS: All scheduler jobs visible to the user
iSelfSchooling-SQL> desc ALL_SCHEDULER_JOBS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
JOB_NAME
NOT
NULL VARCHAR2(30)
JOB_SUBNAME
VARCHAR2(30)
JOB_CREATOR
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
PROGRAM_OWNER
VARCHAR2(4000)
PROGRAM_NAME
VARCHAR2(4000)
JOB_TYPE
VARCHAR2(16)
JOB_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
SCHEDULE_OWNER
VARCHAR2(4000)
SCHEDULE_NAME
VARCHAR2(4000)
SCHEDULE_TYPE
VARCHAR2(12)
START_DATE
TIMESTAMP(6) WITH TIME ZONE
REPEAT_INTERVAL
VARCHAR2(4000)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
EVENT_RULE
VARCHAR2(65)
END_DATE
TIMESTAMP(6) WITH TIME ZONE
JOB_CLASS
VARCHAR2(30)
ENABLED
VARCHAR2(5)
AUTO_DROP
VARCHAR2(5)
RESTARTABLE
VARCHAR2(5)
STATE
VARCHAR2(15)
JOB_PRIORITY
NUMBER
RUN_COUNT
NUMBER
MAX_RUNS
NUMBER
FAILURE_COUNT
NUMBER
MAX_FAILURES
NUMBER
RETRY_COUNT
NUMBER
LAST_START_DATE
TIMESTAMP(6) WITH TIME ZONE
LAST_RUN_DURATION
INTERVAL DAY(9) TO SECOND(0)
NEXT_RUN_DATE
TIMESTAMP(6) WITH TIME ZONE
SCHEDULE_LIMIT
INTERVAL DAY(3) TO SECOND(0)
MAX_RUN_DURATION
INTERVAL DAY(3) TO SECOND(0)
LOGGING_LEVEL
VARCHAR2(4)
STOP_ON_WINDOW_CLOSE
VARCHAR2(5)
INSTANCE_STICKINESS
VARCHAR2(5)
RAISE_EVENTS
VARCHAR2(4000)
SYSTEM
VARCHAR2(5)
JOB_WEIGHT
NUMBER
NLS_ENV
VARCHAR2(4000)
SOURCE
VARCHAR2(128)
DESTINATION
VARCHAR2(128)
COMMENTS
VARCHAR2(240)
FLAGS
NUMBER
ALL_SCHEDULER_JOB_ARGS: All arguments with set values of all
scheduler jobs in the database
iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_ARGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
JOB_NAME
NOT NULL VARCHAR2(30)
ARGUMENT_NAME
VARCHAR2(30)
ARGUMENT_POSITION
NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
VALUE
VARCHAR2(4000)
ANYDATA_VALUE
ANYDATA
OUT_ARGUMENT
VARCHAR2(5)
ALL_SCHEDULER_JOB_CLASSES: All scheduler classes visible to the
user
iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_CLASSES;
Name
Null? Type
----------------------------- -------- --------------------
JOB_CLASS_NAME
NOT
NULL VARCHAR2(30)
RESOURCE_CONSUMER_GROUP
VARCHAR2(30)
SERVICE
VARCHAR2(64)
LOGGING_LEVEL
VARCHAR2(4)
LOG_HISTORY
NUMBER
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_JOB_LOG: Logged information for all scheduler
jobs
iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_LOG;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NOT NULL NUMBER
LOG_DATE
TIMESTAMP(6)
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(65)
JOB_SUBNAME
VARCHAR2(65)
JOB_CLASS
VARCHAR2(30)
OPERATION
VARCHAR2(30)
STATUS
VARCHAR2(30)
USER_NAME
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
ADDITIONAL_INFO
CLOB
ALL_SCHEDULER_JOB_RUN_DETAILS: The details of a job run
iSelfSchooling-SQL> desc
ALL_SCHEDULER_JOB_RUN_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
LOG_DATE
TIMESTAMP(6)
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(65)
JOB_SUBNAME
VARCHAR2(65)
STATUS
VARCHAR2(30)
ERROR#
NUMBER
REQ_START_DATE
TIMESTAMP(6)
ACTUAL_START_DATE
TIMESTAMP(6)
RUN_DURATION
INTERVAL DAY(3)
INSTANCE_ID
NUMBER
SESSION_ID
VARCHAR2(30)
SLAVE_PID
VARCHAR2(30)
CPU_USED
INTERVAL DAY(3)
ADDITIONAL_INFO
VARCHAR2(4000)
ALL_SCHEDULER_PROGRAMS: All scheduler programs visible to the
user
iSelfSchooling-SQL> desc ALL_SCHEDULER_PROGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
PROGRAM_NAME
NOT NULL VARCHAR2(30)
PROGRAM_TYPE
VARCHAR2(16)
PROGRAM_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
ENABLED
VARCHAR2(5)
DETACHED
VARCHAR2(5)
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_PROGRAM_ARGS: All arguments of all scheduler programs
visible to the user
iSelfSchooling-SQL> desc ALL_SCHEDULER_PROGRAM_ARGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
PROGRAM_NAME
NOT NULL VARCHAR2(30)
ARGUMENT_NAME
VARCHAR2(30)
ARGUMENT_POSITION
NOT NULL NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
METADATA_ATTRIBUTE
VARCHAR2(12)
DEFAULT_VALUE
VARCHAR2(4000)
DEFAULT_ANYDATA_VALUE
ANYDATA
OUT_ARGUMENT
VARCHAR2(5)
ALL_SCHEDULER_RUNNING_CHAINS: All job steps of running job chains
visible to the user
iSelfSchooling-SQL> desc ALL_SCHEDULER_RUNNING_CHAINS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(30)
JOB_SUBNAME
VARCHAR2(30)
CHAIN_OWNER
VARCHAR2(30)
CHAIN_NAME
VARCHAR2(30)
STEP_NAME
VARCHAR2(30)
STATE
VARCHAR2(11)
ERROR_CODE
NUMBER
COMPLETED
VARCHAR2(5)
START_DATE
TIMESTAMP(6)
END_DATE
TIMESTAMP(6)
DURATION
INTERVAL DAY(9)
SKIP
VARCHAR2(5)
PAUSE
VARCHAR2(5)
RESTART_ON_RECOVERY
VARCHAR2(5)
STEP_JOB_SUBNAME
VARCHAR2(30)
STEP_JOB_LOG_ID
NUMBER
ALL_SCHEDULER_SCHEDULES: All schedules in the database
iSelfSchooling-SQL> desc ALL_SCHEDULER_SCHEDULES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
SCHEDULE_NAME
NOT NULL VARCHAR2(30)
SCHEDULE_TYPE
VARCHAR2(8)
START_DATE
TIMESTAMP(6) WITH TIME ZONE
REPEAT_INTERVAL
VARCHAR2(4000)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
END_DATE
TIMESTAMP(6) WITH TIME ZONE
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_WINDOWS: All scheduler windows in the database
iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOWS;
Name
Null? Type
----------------------------- -------- --------------------
WINDOW_NAME
NOT NULL VARCHAR2(30)
RESOURCE_PLAN
VARCHAR2(30)
SCHEDULE_OWNER
VARCHAR2(4000)
SCHEDULE_NAME
VARCHAR2(4000)
SCHEDULE_TYPE
VARCHAR2(8)
START_DATE
TIMESTAMP(6)
REPEAT_INTERVAL
VARCHAR2(4000)
END_DATE
TIMESTAMP(6)
DURATION
INTERVAL DAY(3)
WINDOW_PRIORITY
VARCHAR2(4)
NEXT_START_DATE
TIMESTAMP(6)
LAST_START_DATE
TIMESTAMP(6)
ENABLED
VARCHAR2(5)
ACTIVE
VARCHAR2(5)
MANUAL_OPEN_TIME
TIMESTAMP(6)
MANUAL_DURATION
INTERVAL
DAY(3)
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_WINDOW_DETAILS: The details of a window
iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
LOG_DATE
TIMESTAMP(6)
WINDOW_NAME
VARCHAR2(65)
REQ_START_DATE
TIMESTAMP(6)
ACTUAL_START_DATE
TIMESTAMP(6)
WINDOW_DURATION
INTERVAL DAY(3)
ACTUAL_DURATION
INTERVAL DAY(3)
INSTANCE_ID
NUMBER
ADDITIONAL_INFO
VARCHAR2(4000)
ALL_SCHEDULER_WINDOW_GROUPS: All scheduler window groups in the
database
iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
WINDOW_GROUP_NAME
NOT NULL VARCHAR2(30)
ENABLED
VARCHAR2(5)
NUMBER_OF_WINDOWS
NUMBER
NEXT_START_DATE
VARCHAR2(64)
COMMENTS
VARCHAR2(240)
ALL_SCHEDULER_WINDOW_LOG: Logged information for all scheduler
windows
iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_LOG;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NOT NULL NUMBER
LOG_DATE
TIMESTAMP(6)
WINDOW_NAME
VARCHAR2(65)
OPERATION
VARCHAR2(30)
STATUS
VARCHAR2(30)
USER_NAME
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
ADDITIONAL_INFO
CLOB
ALL_SCHEDULER_WINGROUP_MEMBERS: Members of all scheduler window groups
in the database
iSelfSchooling-SQL> desc ALL_SCHEDULER_WINGROUP_MEMBERS;
Name
Null? Type
----------------------------- -------- --------------------
WINDOW_GROUP_NAME
NOT NULL VARCHAR2(30)
WINDOW_NAME
NOT NULL VARCHAR2(30)
ALL_SECONDARY_OBJECTS: All secondary objects for domain
indexes
iSelfSchooling-SQL> desc ALL_SECONDARY_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_OWNER
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_NAME
NOT NULL VARCHAR2(30)
ALL_SEC_RELEVANT_COLS: Security Relevant columns of all VPD
policies for tables or views which the user has access
iSelfSchooling-SQL> desc ALL_SEC_RELEVANT_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
POLICY_GROUP
VARCHAR2(30)
POLICY_NAME
VARCHAR2(30)
SEC_REL_COLUMN
VARCHAR2(30)
COLUMN_OPTION
VARCHAR2(8)
ALL_SEQUENCES: Description of SEQUENCEs accessible to
the user
iSelfSchooling-SQL> desc ALL_SEQUENCES;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_OWNER
NOT NULL VARCHAR2(30)
SEQUENCE_NAME
NOT NULL VARCHAR2(30)
MIN_VALUE
NUMBER
MAX_VALUE
NUMBER
INCREMENT_BY
NOT NULL NUMBER
CYCLE_FLAG
VARCHAR2(1)
ORDER_FLAG
VARCHAR2(1)
CACHE_SIZE
NOT NULL NUMBER
LAST_NUMBER
NOT NULL NUMBER
ALL_SERVICES
iSelfSchooling-SQL> desc ALL_SERVICES;
Name
Null? Type
----------------------------- -------- --------------------
SERVICE_ID
NUMBER
NAME
VARCHAR2(64)
NAME_HASH
NUMBER
NETWORK_NAME
VARCHAR2(512)
CREATION_DATE
DATE
CREATION_DATE_HASH
NUMBER
FAILOVER_METHOD
VARCHAR2(64)
FAILOVER_TYPE
VARCHAR2(64)
FAILOVER_RETRIES
NUMBER(10)
FAILOVER_DELAY
NUMBER(10)
MIN_CARDINALITY
NUMBER
MAX_CARDINALITY
NUMBER
GOAL
VARCHAR2(12)
DTP
VARCHAR2(1)
ENABLED
VARCHAR2(3)
AQ_HA_NOTIFICATIONS
VARCHAR2(3)
CLB_GOAL
VARCHAR2(5)
ALL_SNAPSHOTS: Snapshots the user can access
iSelfSchooling-SQL> desc ALL_SNAPSHOTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT
NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
MASTER_VIEW
VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
LAST_REFRESH
DATE
ERROR
NUMBER
FR_OPERATIONS
VARCHAR2(10)
CR_OPERATIONS
VARCHAR2(10)
TYPE
VARCHAR2(8)
NEXT
VARCHAR2(200)
START_WITH
DATE
REFRESH_GROUP
NUMBER
UPDATE_TRIG
VARCHAR2(30)
UPDATE_LOG
VARCHAR2(30)
QUERY
LONG
MASTER_ROLLBACK_SEG
VARCHAR2(30)
STATUS
VARCHAR2(7)
REFRESH_MODE
VARCHAR2(8)
PREBUILT
VARCHAR2(3)
|