|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_CLUSTER_HASH_EXPRESSIONS: Hash functions for all accessible
clusters
iSelfSchooling-SQL> desc ALL_CLUSTER_HASH_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CLUSTER_NAME
NOT NULL VARCHAR2(30)
HASH_EXPRESSION
LONG
ALL_COLL_TYPES: Description of named collection types
accessible to the user
iSelfSchooling-SQL> desc ALL_COLL_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
COLL_TYPE
NOT NULL VARCHAR2(30)
UPPER_BOUND
NUMBER
ELEM_TYPE_MOD
VARCHAR2(7)
ELEM_TYPE_OWNER
VARCHAR2(30)
ELEM_TYPE_NAME
VARCHAR2(30)
LENGTH
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
ELEM_STORAGE
VARCHAR2(7)
NULLS_STORED
VARCHAR2(3)
ALL_COL_COMMENTS: Comments on columns of accessible
tables and views
iSelfSchooling-SQL> desc ALL_COL_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_COL_PRIVS: Grants on columns for which the user is
the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc ALL_COL_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTOR
NOT NULL VARCHAR2(30)
GRANTEE
NOT NULL VARCHAR2(30)
TABLE_SCHEMA
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_COL_PRIVS_MADE: Grants on columns for which the user is
owner or grantor
iSelfSchooling-SQL> desc ALL_COL_PRIVS_MADE;
Name
Null?
Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_COL_PRIVS_RECD: Grants on columns for which the user,
PUBLIC or enabled role is the grantee
iSelfSchooling-SQL> desc ALL_COL_PRIVS_RECD;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT
NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_CONSTRAINTS: Constraint definitions on accessible
tables
iSelfSchooling-SQL> desc ALL_CONSTRAINTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CONSTRAINT_NAME
NOT NULL VARCHAR2(30)
CONSTRAINT_TYPE
VARCHAR2(1)
TABLE_NAME
NOT NULL VARCHAR2(30)
SEARCH_CONDITION
LONG
R_OWNER
VARCHAR2(30)
R_CONSTRAINT_NAME
VARCHAR2(30)
DELETE_RULE
VARCHAR2(9)
STATUS
VARCHAR2(8)
DEFERRABLE
VARCHAR2(14)
DEFERRED
VARCHAR2(9)
VALIDATED
VARCHAR2(13)
GENERATED
VARCHAR2(14)
BAD
VARCHAR2(3)
RELY
VARCHAR2(4)
LAST_CHANGE
DATE
INDEX_OWNER
VARCHAR2(30)
INDEX_NAME
VARCHAR2(30)
INVALID
VARCHAR2(7)
VIEW_RELATED
VARCHAR2(14)
ALL_CONS_COLUMNS: Information about accessible columns in
constraint definitions
iSelfSchooling-SQL> desc ALL_CONS_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CONSTRAINT_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
POSITION
NUMBER
ALL_CONS_OBJ_COLUMNS: List of types an object column or
attribute is constrained to in the tables accessible to the user
iSelfSchooling-SQL> desc ALL_CONS_OBJ_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
CONS_TYPE_OWNER
VARCHAR2(30)
CONS_TYPE_NAME
VARCHAR2(30)
CONS_TYPE_ONLY
VARCHAR2(15)
ALL_CONTEXT: Description of all active context
namespaces under the current session
iSelfSchooling-SQL> desc ALL_CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
NOT NULL VARCHAR2(30)
SCHEMA
NOT
NULL VARCHAR2(30)
PACKAGE
NOT NULL VARCHAR2(30)
ALL_DB_LINKS: Database links accessible to the user
iSelfSchooling-SQL> desc ALL_DB_LINKS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DB_LINK
NOT NULL VARCHAR2(128)
USERNAME
VARCHAR2(30)
HOST
VARCHAR2(2000)
CREATED
NOT NULL DATE
ALL_DEF_AUDIT_OPTS: Auditing options for newly created
objects
iSelfSchooling-SQL> desc ALL_DEF_AUDIT_OPTS;
Name
Null? Type
----------------------------- -------- --------------------
ALT
VARCHAR2(3)
AUD
VARCHAR2(3)
COM
VARCHAR2(3)
DEL
VARCHAR2(3)
GRA
VARCHAR2(3)
IND
VARCHAR2(3)
INS
VARCHAR2(3)
LOC
VARCHAR2(3)
REN
VARCHAR2(3)
SEL
VARCHAR2(3)
UPD
VARCHAR2(3)
REF
CHAR(3)
EXE
VARCHAR2(3)
FBK
VARCHAR2(3)
REA
VARCHAR2(3)
ALL_DEPENDENCIES: Dependencies to and from objects
accessible to the user
iSelfSchooling-SQL> desc ALL_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL
VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(17)
REFERENCED_OWNER
VARCHAR2(30)
REFERENCED_NAME
VARCHAR2(64)
REFERENCED_TYPE
VARCHAR2(17)
REFERENCED_LINK_NAME
VARCHAR2(128)
DEPENDENCY_TYPE
VARCHAR2(4)
ALL_DEQUEUE_QUEUES: All queues accessible to the user
iSelfSchooling-SQL> desc ALL_DEQUEUE_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_DIMENSIONS: Description of the dimension objects
accessible to the DBA
iSelfSchooling-SQL> desc ALL_DIMENSIONS;
|