ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_PROBE_OBJECTS
iSelfSchooling-SQL> desc ALL_PROBE_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_ID
NOT
NULL NUMBER
DATA_OBJECT_ID
NUMBER
OBJECT_TYPE
VARCHAR2(19)
CREATED
NOT NULL DATE
LAST_DDL_TIME
NOT NULL DATE
TIMESTAMP
VARCHAR2(19)
STATUS
VARCHAR2(7)
TEMPORARY
VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
DEBUGINFO
VARCHAR2(1)
ALL_PROCEDURES: Description of all procedures available
to the user
iSelfSchooling-SQL> desc ALL_PROCEDURES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
PROCEDURE_NAME
VARCHAR2(30)
AGGREGATE
VARCHAR2(3)
PIPELINED
VARCHAR2(3)
IMPLTYPEOWNER
VARCHAR2(30)
IMPLTYPENAME
VARCHAR2(30)
PARALLEL
VARCHAR2(3)
INTERFACE
VARCHAR2(3)
DETERMINISTIC
VARCHAR2(3)
AUTHID
VARCHAR2(12)
ALL_PROPAGATIONS: treams propagation seen by the user
iSelfSchooling-SQL> desc ALL_PROPAGATION;
Name
Null? Type
----------------------------- -------- --------------------
PROPAGATION_NAME
NOT NULL VARCHAR2(30)
SOURCE_QUEUE_OWNER
VARCHAR2(30)
SOURCE_QUEUE_NAME
VARCHAR2(30)
DESTINATION_QUEUE_OWNER
VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(30)
DESTINATION_DBLINK
VARCHAR2(128)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
QUEUE_TO_QUEUE
VARCHAR2(5)
STATUS
VARCHAR2(8)
ERROR_MESSAGE
VARCHAR2(4000)
ERROR_DATE
DATE
ALL_PUBLISHED_COLUMNS: Source columns available for Change
Data Capture
iSelfSchooling-SQL> desc ALL_PUBLISHED_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
CHANGE_SET_NAME
NOT NULL VARCHAR2(30)
PUB_ID
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
ALL_QUEUES: All queues accessible to the user
iSelfSchooling-SQL> desc ALL_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT NULL VARCHAR2(30)
QID
NOT NULL NUMBER
QUEUE_TYPE
VARCHAR2(20)
MAX_RETRIES
NUMBER
RETRY_DELAY
NUMBER
ENQUEUE_ENABLED
VARCHAR2(7)
DEQUEUE_ENABLED
VARCHAR2(7)
RETENTION
VARCHAR2(40)
USER_COMMENT
VARCHAR2(50)
NETWORK_NAME
VARCHAR2(512)
ALL_QUEUE_PUBLISHERS
iSelfSchooling-SQL> desc ALL_QUEUE_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_OWNER
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
PUBLISHER_NAME
VARCHAR2(30)
PUBLISHER_ADDRESS
VARCHAR2(1024)
PUBLISHER_PROTOCOL
NUMBER
PUBLISHER_RULE
VARCHAR2(2000)
PUBLISHER_RULE_NAME
VARCHAR2(61)
PUBLISHER_RULESET
VARCHAR2(61)
PUBLISHER_TRANSFORMATION
VARCHAR2(61)
ALL_QUEUE_SUBSCRIBERS: All queue subscribers accessible to
user
iSelfSchooling-SQL> desc ALL_QUEUE_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT NULL VARCHAR2(30)
CONSUMER_NAME
VARCHAR2(30)
ADDRESS
VARCHAR2(1024)
PROTOCOL
NUMBER
TRANSFORMATION
VARCHAR2(61)
DELIVERY_MODE
VARCHAR2(22)
QUEUE_TO_QUEUE
VARCHAR2(5)
ALL_QUEUE_TABLES: All queue tables accessible to the user
iSelfSchooling-SQL> desc ALL_QUEUE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
QUEUE_TABLE
VARCHAR2(30)
TYPE
VARCHAR2(7)
OBJECT_TYPE
VARCHAR2(61)
SORT_ORDER
VARCHAR2(22)
RECIPIENTS
VARCHAR2(8)
MESSAGE_GROUPING
VARCHAR2(13)
COMPATIBLE
VARCHAR2(6)
PRIMARY_INSTANCE
NUMBER
SECONDARY_INSTANCE
NUMBER
OWNER_INSTANCE
NUMBER
USER_COMMENT
VARCHAR2(50)
SECURE
VARCHAR2(3)
ALL_REFRESH: All the refresh groups that the user
can touch
iSelfSchooling-SQL> desc ALL_REFRESH;
Name
Null? Type
----------------------------- -------- --------------------
ROWNER
NOT NULL VARCHAR2(30)
RNAME
NOT NULL VARCHAR2(30)
REFGROUP
NUMBER
IMPLICIT_DESTROY
VARCHAR2(1)
PUSH_DEFERRED_RPC
VARCHAR2(1)
REFRESH_AFTER_ERRORS
VARCHAR2(1)
ROLLBACK_SEG
VARCHAR2(30)
JOB
NUMBER
NEXT_DATE
DATE
INTERVAL
VARCHAR2(200)
BROKEN
VARCHAR2(1)
PURGE_OPTION
NUMBER(38)
PARALLELISM
NUMBER(38)
HEAP_SIZE
NUMBER(38)
ALL_REFRESH_CHILDREN: All the objects in refresh groups,
where the user can touch the group
iSelfSchooling-SQL> desc ALL_REFRESH_CHILDREN;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(30)
ROWNER
NOT NULL VARCHAR2(30)
RNAME
NOT NULL VARCHAR2(30)
REFGROUP
NUMBER
IMPLICIT_DESTROY
VARCHAR2(1)
PUSH_DEFERRED_RPC
VARCHAR2(1)
REFRESH_AFTER_ERRORS
VARCHAR2(1)
ROLLBACK_SEG
VARCHAR2(30)
JOB
NUMBER
NEXT_DATE
DATE
INTERVAL
VARCHAR2(200)
BROKEN
VARCHAR2(1)
PURGE_OPTION
NUMBER(38)
PARALLELISM
NUMBER(38)
HEAP_SIZE
NUMBER(38)
ALL_REFRESH_DEPENDENCIES: Description of the detail tables that
materialized views depend on for refresh
iSelfSchooling-SQL> desc ALL_REFRESH_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARENT_OBJECT_TYPE
CHAR(17)
OLDEST_REFRESH_SCN
NUMBER
OLDEST_REFRESH_DATE
DATE
ALL_REFS: Description of REF columns contained in
tables accessible to the user
iSelfSchooling-SQL> desc ALL_REFS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
WITH_ROWID
VARCHAR2(3)
IS_SCOPED
VARCHAR2(3)
SCOPE_TABLE_OWNER
VARCHAR2(30)
SCOPE_TABLE_NAME
VARCHAR2(30)
OBJECT_ID_TYPE
VARCHAR2(33)
ALL_REGISTERED_MVIEWS: Remote materialized views of local
tables that the user can see
iSelfSchooling-SQL> desc ALL_REGISTERED_MVIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MVIEW_SITE
NOT NULL VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
MVIEW_ID
NUMBER(38)
VERSION
VARCHAR2(26)
QUERY_TXT
LONG
ALL_REGISTERED_SNAPSHOTS: Remote snapshots of local tables that
the user can see
iSelfSchooling-SQL> desc ALL_REGISTERED_SNAPSHOTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL
VARCHAR2(30)
SNAPSHOT_SITE
NOT NULL VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
SNAPSHOT_ID
NUMBER(38)
VERSION
VARCHAR2(17)
QUERY_TXT
LONG
ALL_REGISTRY_BANNERS
iSelfSchooling-SQL> desc ALL_REGISTRY_BANNERS;
Name
Null? Type
----------------------------- -------- --------------------
BANNER
VARCHAR2(80)
ALL_REPAUDIT_ATTRIBUTE: Information about attributes
automatically maintained for replication
iSelfSchooling-SQL> desc ALL_REPAUDIT_ATTRIBUTE;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
DATA_LENGTH
NUMBER(38)
SOURCE
NOT NULL VARCHAR2(92)
ALL_REPAUDIT_COLUMN: Information about columns in all shadow
tables for replicated tables which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPAUDIT_COLUMN;
Name
Null?
Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
BASE_SNAME
NOT NULL VARCHAR2(30)
BASE_ONAME
NOT NULL VARCHAR2(30)
BASE_CONFLICT_TYPE
VARCHAR2(10)
BASE_REFERENCE_NAME
NOT NULL VARCHAR2(30)
ATTRIBUTE
NOT NULL VARCHAR2(30)
ALL_REPCAT
iSelfSchooling-SQL> desc ALL_REPCAT;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
MASTER
VARCHAR2(1)
STATUS
VARCHAR2(9)
SCHEMA_COMMENT
VARCHAR2(80)
GNAME
NOT NULL VARCHAR2(30)
FNAME
VARCHAR2(30)
RPC_PROCESSING_DISABLED
VARCHAR2(1)
OWNER
NOT NULL VARCHAR2(30)
ALL_REPCATLOG: Information about asynchronous
administration requests
iSelfSchooling-SQL> desc ALL_REPCATLOG;
Name
Null? Type
----------------------------- -------- --------------------
ID
NUMBER
SOURCE
VARCHAR2(128)
USERID
VARCHAR2(30)
TIMESTAMP
DATE
ROLE
VARCHAR2(9)
MASTER
VARCHAR2(128)
SNAME
VARCHAR2(30)
REQUEST
VARCHAR2(29)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
STATUS
VARCHAR2(14)
MESSAGE
VARCHAR2(200)
ERRNUM
NUMBER
GNAME
VARCHAR2(30)
ALL_REPCOLUMN: Replicated top-level columns (table)
sorted alphabetically in ascending order
iSelfSchooling-SQL> desc ALL_REPCOLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(8)
CNAME
VARCHAR2(4000)
ID
NUMBER
POS
NUMBER
COMPARE_OLD_ON_DELETE
VARCHAR2(1)
COMPARE_OLD_ON_UPDATE
VARCHAR2(1)
SEND_OLD_ON_DELETE
VARCHAR2(1)
SEND_OLD_ON_UPDATE
VARCHAR2(1)
CTYPE
VARCHAR2(106)
CTYPE_TOID
RAW(16)
CTYPE_OWNER
VARCHAR2(30)
CTYPE_HASHCODE
VARCHAR2(34)
CTYPE_MOD
VARCHAR2(3)
DATA_LENGTH
VARCHAR2(40)
DATA_PRECISION
VARCHAR2(40)
DATA_SCALE
VARCHAR2(40)
NULLABLE
VARCHAR2(1)
CHARACTER_SET_NAME
VARCHAR2(44)
TOP
VARCHAR2(30)
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
ALL_REPCOLUMN_GROUP: All column groups of replicated tables
which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPCOLUMN_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
GROUP_NAME
NOT NULL VARCHAR2(30)
GROUP_COMMENT
VARCHAR2(80)
ALL_REPCONFLICT: All conflicts with available
resolutions for user's replicated tables
iSelfSchooling-SQL> desc ALL_REPCONFLICT;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
ALL_REPDDL: Arguments that do not fit in a single
repcat log record
iSelfSchooling-SQL> desc ALL_REPDDL;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
SOURCE
VARCHAR2(128)
ROLE
VARCHAR2(1)
MASTER
VARCHAR2(128)
LINE
NUMBER(38)
TEXT
VARCHAR2(2000)
DDL_NUM
NUMBER(38)
ALL_REPFLAVORS: Flavors defined for replicated object
groups
iSelfSchooling-SQL> desc ALL_REPFLAVORS;
Name
Null? Type
----------------------------- -------- --------------------
FLAVOR_ID
NOT NULL NUMBER
GNAME
NOT NULL VARCHAR2(30)
FNAME
VARCHAR2(30)
CREATION_DATE
DATE
CREATED_BY
VARCHAR2(30)
PUBLISHED
VARCHAR2(1)
GROUP_OWNER
VARCHAR2(30)
ALL_REPFLAVOR_COLUMNS: Replicated columns in flavors
iSelfSchooling-SQL> desc ALL_REPFLAVOR_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
FNAME
VARCHAR2(30)
GNAME
VARCHAR2(30)
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
CNAME
VARCHAR2(4000)
TYPE
VARCHAR2(30)
POS
NUMBER
GROUP_OWNER
VARCHAR2(30)
TYPE_TOID
RAW(16)
TYPE_OWNER
VARCHAR2(30)
TYPE_HASHCODE
VARCHAR2(34)
TYPE_MOD
VARCHAR2(3)
TOP
VARCHAR2(30)
ALL_REPFLAVOR_OBJECTS: Replicated objects in flavors
iSelfSchooling-SQL> desc ALL_REPFLAVOR_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
FNAME
VARCHAR2(30)
GNAME
NOT NULL VARCHAR2(30)
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
GROUP_OWNER
NOT NULL VARCHAR2(30)
ALL_REPGENERATED: Objects generated to support
replication
iSelfSchooling-SQL> desc ALL_REPGENERATED;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
BASE_SNAME
VARCHAR2(30)
BASE_ONAME
VARCHAR2(30)
BASE_TYPE
VARCHAR2(12)
PACKAGE_PREFIX
VARCHAR2(30)
PROCEDURE_PREFIX
VARCHAR2(30)
DISTRIBUTED
VARCHAR2(1)
REASON
VARCHAR2(30)
ALL_REPGENOBJECTS: Objects generated to support
replication
iSelfSchooling-SQL> desc ALL_REPGENOBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
BASE_SNAME
VARCHAR2(30)
BASE_ONAME
VARCHAR2(30)
BASE_TYPE
VARCHAR2(12)
PACKAGE_PREFIX
VARCHAR2(30)
PROCEDURE_PREFIX
VARCHAR2(30)
DISTRIBUTED
VARCHAR2(1)
REASON
VARCHAR2(30)
ALL_REPGROUP: Information about replicated object
groups
iSelfSchooling-SQL> desc ALL_REPGROUP;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
MASTER
VARCHAR2(1)
STATUS
VARCHAR2(9)
SCHEMA_COMMENT
VARCHAR2(80)
GNAME
NOT
NULL VARCHAR2(30)
FNAME
VARCHAR2(30)
RPC_PROCESSING_DISABLED
VARCHAR2(1)
OWNER
NOT NULL VARCHAR2(30)
ALL_REPGROUPED_COLUMN: Columns in the all column groups of
replicated tables which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPGROUPED_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
GROUP_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
ALL_REPGROUP_PRIVILEGES: Information about users who are
registered for object group privileges
iSelfSchooling-SQL> desc ALL_REPGROUP_PRIVILEGES;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
NOT NULL VARCHAR2(30)
GNAME
VARCHAR2(30)
CREATED
NOT NULL DATE
RECEIVER
VARCHAR2(1)
PROXY_SNAPADMIN
VARCHAR2(1)
OWNER
VARCHAR2(30)
ALL_REPKEY_COLUMNS: Primary columns for a table using
column-level replication
iSelfSchooling-SQL> desc ALL_REPKEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT
NULL VARCHAR2(30)
COL
VARCHAR2(4000)
ALL_REPOBJECT: Information about replicated objects
iSelfSchooling-SQL> desc ALL_REPOBJECT;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(16)
STATUS
VARCHAR2(10)
GENERATION_STATUS
VARCHAR2(9)
ID
NUMBER
OBJECT_COMMENT
VARCHAR2(80)
GNAME
VARCHAR2(30)
MIN_COMMUNICATION
VARCHAR2(1)
REPLICATION_TRIGGER_EXISTS VARCHAR2(1)
INTERNAL_PACKAGE_EXISTS
VARCHAR2(1)
GROUP_OWNER
VARCHAR2(30)
NESTED_TABLE
VARCHAR2(1)
ALL_REPPARAMETER_COLUMN: All columns used for resolving
conflicts in replicated tables which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPPARAMETER_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME VARCHAR2(30)
ONAME
VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
VARCHAR2(30)
SEQUENCE_NO
NUMBER
METHOD_NAME
VARCHAR2(80)
FUNCTION_NAME
VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
PARAMETER_TABLE_NAME
VARCHAR2(30)
PARAMETER_COLUMN_NAME
VARCHAR2(4000)
PARAMETER_SEQUENCE_NO
NUMBER
ALL_REPPRIORITY: Values and their corresponding
priorities in all priority groups which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPPRIORITY;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
PRIORITY_GROUP
NOT NULL VARCHAR2(30)
PRIORITY
NOT NULL NUMBER
DATA_TYPE
VARCHAR2(9)
FIXED_DATA_LENGTH
NUMBER(38)
CHAR_VALUE
CHAR(255)
VARCHAR2_VALUE
VARCHAR2(4000)
NUMBER_VALUE
NUMBER
DATE_VALUE
DATE
RAW_VALUE
RAW(2000)
GNAME
NOT NULL VARCHAR2(30)
NCHAR_VALUE
NCHAR(500)
NVARCHAR2_VALUE
NVARCHAR2(1000)
LARGE_CHAR_VALUE
CHAR(2000)
ALL_REPPRIORITY_GROUP: Information about all priority groups
which are accessible to the user
iSelfSchooling-SQL> desc ALL_REPPRIORITY_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
PRIORITY_GROUP
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
FIXED_DATA_LENGTH
NUMBER(38)
PRIORITY_COMMENT
VARCHAR2(80)
GNAME
NOT NULL VARCHAR2(30)
|