ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_ALL_TABLES: Description of all object and
relational tables accessible to the user
iSelfSchooling-SQL> desc ALL_ALL_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
OBJECT_ID_TYPE
VARCHAR2(16)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE
VARCHAR2(30)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
ALL_APPLY: Details about each apply process that
dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_OWNER
NOT NULL VARCHAR2(30)
APPLY_CAPTURED
VARCHAR2(3)
RULE_SET_NAME
VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
APPLY_USER
VARCHAR2(30)
APPLY_DATABASE_LINK
VARCHAR2(128)
APPLY_TAG
RAW(2000)
DDL_HANDLER
VARCHAR2(98)
PRECOMMIT_HANDLER
VARCHAR2(98)
MESSAGE_HANDLER
VARCHAR2(98)
STATUS
VARCHAR2(8)
MAX_APPLIED_MESSAGE_NUMBER NUMBER
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
STATUS_CHANGE_TIME
DATE
ERROR_NUMBER
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
ALL_APPLY_CONFLICT_COLUMNS: Details about conflict resolution on tables visible to the current
user
iSelfSchooling-SQL> desc ALL_APPLY_CONFLICT_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
METHOD_NAME
VARCHAR2(92)
RESOLUTION_COLUMN
VARCHAR2(4000)
COLUMN_NAME
VARCHAR2(30)
APPLY_DATABASE_LINK
VARCHAR2(128)
ALL_APPLY_DML_HANDLERS: Details about the dml handler on tables
visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_DML_HANDLERS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OPERATION_NAME
VARCHAR2(13)
USER_PROCEDURE
VARCHAR2(98)
ERROR_HANDLER
VARCHAR2(1)
APPLY_DATABASE_LINK
VARCHAR2(128)
APPLY_NAME
VARCHAR2(30)
ASSEMBLE_LOBS
VARCHAR2(1)
ALL_APPLY_ENQUEUE: Details about the apply enqueue action
for user accessible rules where the destination queue exists and is
visible to the user
iSelfSchooling-SQL> desc ALL_APPLY_ENQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(4000)
ALL_APPLY_ERROR: Error transactions that were generated
after dequeuing from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_ERROR;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
QUEUE_OWNER
VARCHAR2(30)
LOCAL_TRANSACTION_ID
VARCHAR2(22)
SOURCE_DATABASE
VARCHAR2(128)
SOURCE_TRANSACTION_ID
VARCHAR2(22)
SOURCE_COMMIT_SCN
NUMBER
MESSAGE_NUMBER
NUMBER
ERROR_NUMBER
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
RECIPIENT_ID
NUMBER
RECIPIENT_NAME
VARCHAR2(30)
MESSAGE_COUNT
NUMBER
ERROR_CREATION_TIME
DATE
ALL_APPLY_EXECUTE: Details about the apply execute action for all rules visible to the
user
iSelfSchooling-SQL> desc ALL_APPLY_EXECUTE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
EXECUTE_EVENT
VARCHAR2(2)
ALL_APPLY_KEY_COLUMNS: Alternative key columns for a STREAMS
table visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
APPLY_DATABASE_LINK
VARCHAR2(128)
ALL_APPLY_PARAMETERS: Details about parameters of each apply
process that dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
PARAMETER
NOT NULL VARCHAR2(128)
VALUE
VARCHAR2(4000)
SET_BY_USER
VARCHAR2(3)
ALL_APPLY_PROGRESS: Information about the progress made by
the apply process that dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
SOURCE_DATABASE
NOT NULL VARCHAR2(128)
APPLIED_MESSAGE_NUMBER
NOT NULL NUMBER
OLDEST_MESSAGE_NUMBER
NOT NULL NUMBER
APPLY_TIME
DATE
APPLIED_MESSAGE_CREATE_TIME DATE
OLDEST_TRANSACTION_ID
VARCHAR2(22)
ALL_APPLY_TABLE_COLUMNS: Details about the columns of
destination table object visible to the user
iSelfSchooling-SQL> desc ALL_APPLY_TABLE_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COMPARE_OLD_ON_DELETE
VARCHAR2(3)
COMPARE_OLD_ON_UPDATE
VARCHAR2(3)
APPLY_DATABASE_LINK
VARCHAR2(128)
ALL_ARGUMENTS: Arguments in object accessible to the
user
iSelfSchooling-SQL> desc ALL_ARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
PACKAGE_NAME
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
OVERLOAD
VARCHAR2(40)
ARGUMENT_NAME
VARCHAR2(30)
POSITION
NOT NULL NUMBER
SEQUENCE
NOT NULL NUMBER
DATA_LEVEL
NOT NULL NUMBER
DATA_TYPE
VARCHAR2(30)
DEFAULT_VALUE
LONG
DEFAULT_LENGTH
NUMBER
IN_OUT
VARCHAR2(9)
DATA_LENGTH
NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
RADIX
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
TYPE_OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
TYPE_SUBNAME
VARCHAR2(30)
TYPE_LINK
VARCHAR2(128)
PLS_TYPE
VARCHAR2(30)
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
ALL_ASSOCIATIONS: All associations available to the user
iSelfSchooling-SQL> desc ALL_ASSOCIATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(9)
STATSTYPE_SCHEMA
VARCHAR2(30)
STATSTYPE_NAME
VARCHAR2(30)
DEF_SELECTIVITY
NUMBER
DEF_CPU_COST
NUMBER
DEF_IO_COST
NUMBER
DEF_NET_COST
NUMBER
INTERFACE_VERSION
NUMBER
ALL_AUDIT_POLICIES: All fine grained auditing policies in
the database
iSelfSchooling-SQL> desc ALL_AUDIT_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_SCHEMA
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
POLICY_NAME
VARCHAR2(30)
POLICY_TEXT
VARCHAR2(4000)
POLICY_COLUMN
VARCHAR2(30)
PF_SCHEMA
VARCHAR2(30)
PF_PACKAGE
VARCHAR2(30)
PF_FUNCTION
VARCHAR2(30)
ENABLED
VARCHAR2(3)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
AUDIT_TRAIL
VARCHAR2(12)
POLICY_COLUMN_OPTIONS
VARCHAR2(11)
ALL_AUDIT_POLICY_COLUMNS: All fine grained auditing policy
columns in the database
iSelfSchooling-SQL> desc ALL_AUDIT_POLICY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_SCHEMA
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
POLICY_NAME
VARCHAR2(30)
POLICY_COLUMN
VARCHAR2(30)
ALL_AWS: Analytic Workspaces accessible to the
user
iSelfSchooling-SQL> desc ALL_AWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
AW_VERSION
VARCHAR2(4)
PAGESPACES
NUMBER
GENERATIONS
NUMBER
ALL_AW_AC: Active Catalog Analytic Workspaces
accessible to the user
iSelfSchooling-SQL> desc ALL_AW_AC;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
ALL_AW_AC_10G
iSelfSchooling-SQL> desc ALL_AW_AC_10G;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
ALL_AW_OBJ: Objects in Analytic Workspaces
accessible to the user
iSelfSchooling-SQL> desc ALL_AW_OBJ;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
OBJ_ID
NUMBER(20)
OBJ_NAME
VARCHAR2(256)
OBJ_TYPE
NUMBER(4)
PART_NAME
VARCHAR2(256)
ALL_AW_PROP: Object properties in Analytic
Workspaces accessible to the user
iSelfSchooling-SQL> desc ALL_AW_PROP;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
OBJ_ID
NUMBER(20)
OBJ_NAME
VARCHAR2(256)
PROPERTY_NAME
VARCHAR2(256)
PROPERTY_TYPE
VARCHAR2(4000)
PROPERTY_VALUE
VARCHAR2(4000)
FULL_PROPERTY_VALUE
CLOB
PROPERTY_VALUE_LENGTH
NUMBER
ALL_AW_PROP_NAME: Analytic Workspace property names
accessible to the user
iSelfSchooling-SQL> desc ALL_AW_PROP_NAME;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
OBJ_ID
NUMBER(20)
OBJ_NAME
VARCHAR2(256)
PROPERTY_NAME
VARCHAR2(256)
ALL_AW_PS: Pagespaces in Analytic Workspaces
accessible to the user
iSelfSchooling-SQL> desc ALL_AW_PS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
AW_NUMBER
NOT NULL NUMBER
AW_NAME
VARCHAR2(30)
PSNUMBER
NUMBER(10)
GENERATIONS
NUMBER
MAXPAGES
NUMBER
ALL_BASE_TABLE_MVIEWS: All materialized views with log(s) in
the database that the user can see
iSelfSchooling-SQL> desc ALL_BASE_TABLE_MVIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MASTER
NOT NULL VARCHAR2(30)
MVIEW_LAST_REFRESH_TIME
NOT NULL DATE
MVIEW_ID
NUMBER(38)
ALL_CAPTURE: Details about each capture process that
stores the captured changes in a queue visible to the current user
iSelfSchooling-SQL> desc ALL_CAPTURE;
Name
Null? Type
----------------------------- -------- --------------------
CAPTURE_NAME
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_OWNER
NOT NULL VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
CAPTURE_USER
VARCHAR2(30)
START_SCN
NUMBER
STATUS
VARCHAR2(8)
CAPTURED_SCN
NUMBER
APPLIED_SCN
NUMBER
USE_DATABASE_LINK
VARCHAR2(3)
FIRST_SCN
NUMBER
SOURCE_DATABASE
VARCHAR2(128)
SOURCE_DBID
NUMBER
SOURCE_RESETLOGS_SCN
NUMBER
SOURCE_RESETLOGS_TIME
NUMBER
LOGMINER_ID
NUMBER
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
MAX_CHECKPOINT_SCN
NUMBER
REQUIRED_CHECKPOINT_SCN
NUMBER
LOGFILE_ASSIGNMENT
VARCHAR2(8)
STATUS_CHANGE_TIME
DATE
ERROR_NUMBER
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
VERSION
VARCHAR2(64)
CAPTURE_TYPE
VARCHAR2(10)
LAST_ENQUEUED_SCN
NUMBER
CHECKPOINT_RETENTION_TIME
NUMBER
ALL_CAPTURE_EXTRA_ATTRIBUTES: Extra attributes for a capture process
that is visible to the current user
iSelfSchooling-SQL> desc ALL_CAPTURE_EXTRA_ATTRIBUTES;
Name
Null? Type
----------------------------- -------- --------------------
CAPTURE_NAME
NOT NULL VARCHAR2(30)
ATTRIBUTE_NAME
NOT NULL VARCHAR2(30)
INCLUDE
VARCHAR2(3)
ROW_ATTRIBUTE
VARCHAR2(3)
DDL_ATTRIBUTE
VARCHAR2(3)
ALL_CAPTURE_PARAMETERS: Details about parameters for each
capture process that stores the captured changes in a queue visible to the
current user
iSelfSchooling-SQL> desc ALL_CAPTURE_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
CAPTURE_NAME
NOT NULL VARCHAR2(30)
PARAMETER
NOT NULL VARCHAR2(128)
VALUE
VARCHAR2(4000)
SET_BY_USER
VARCHAR2(3)
ALL_CAPTURE_PREPARED_DATABASE: Is the local database prepared for
instantiation?
iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_DATABASE;
Name
Null? Type
----------------------------- -------- --------------------
TIMESTAMP
DATE
SUPPLEMENTAL_LOG_DATA_PK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_UI
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_FK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_ALL
VARCHAR2(8)
ALL_CAPTURE_PREPARED_SCHEMAS: All user schemas at the local database
that are prepared for instantiation
iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_SCHEMAS;
Name
Null? Type
----------------------------- -------- --------------------
SCHEMA_NAME
NOT NULL VARCHAR2(30)
TIMESTAMP
DATE
SUPPLEMENTAL_LOG_DATA_PK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_UI
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_FK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_ALL
VARCHAR2(8)
ALL_CAPTURE_PREPARED_TABLES: All tables visible to the current user
that are prepared for instantiation
iSelfSchooling-SQL> desc ALL_CAPTURE_PREPARED_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SCN
NOT NULL NUMBER
TIMESTAMP
DATE
SUPPLEMENTAL_LOG_DATA_PK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_UI
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_FK
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_ALL
VARCHAR2(8)
ALL_CATALOG: All tables, views, synonyms, sequences
accessible to the user
iSelfSchooling-SQL> desc ALL_CATALOG;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
ALL_CLUSTERS: Description of clusters accessible to
the user
iSelfSchooling-SQL> desc ALL_CLUSTERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CLUSTER_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
KEY_SIZE
NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT
NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
AVG_BLOCKS_PER_KEY
NUMBER
CLUSTER_TYPE
VARCHAR2(5)
FUNCTION
VARCHAR2(15)
HASHKEYS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
BUFFER_POOL
VARCHAR2(7)
SINGLE_TABLE
VARCHAR2(5)
DEPENDENCIES
VARCHAR2(8)
|