|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_PART_KEY_COLUMNS
iSelfSchooling-SQL> desc USER_PART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
USER_PART_LOBS
iSelfSchooling-SQL> desc USER_PART_LOBS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_INDEX_NAME
NOT NULL VARCHAR2(30)
DEF_CHUNK
NOT NULL NUMBER
DEF_PCTVERSION
NOT NULL NUMBER
DEF_CACHE
VARCHAR2(10)
DEF_IN_ROW
VARCHAR2(3)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
VARCHAR2(40)
DEF_FREELIST_GROUPS
VARCHAR2(40)
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
USER_PART_TABLES
iSelfSchooling-SQL> desc USER_PART_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
STATUS
VARCHAR2(8)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NUMBER
DEF_PCT_USED
NUMBER
DEF_INI_TRANS
NUMBER
DEF_MAX_TRANS
NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NUMBER
DEF_FREELIST_GROUPS
NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_COMPRESSION
VARCHAR2(8)
DEF_BUFFER_POOL
VARCHAR2(7)
USER_PASSWORD_LIMITS: Display password limits of the user
iSelfSchooling-SQL> desc USER_PASSWORD_LIMITS;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
NOT NULL VARCHAR2(32)
LIMIT
VARCHAR2(40)
USER_PENDING_CONV_TABLES: All user's tables which are not
upgraded to the latest type version
iSelfSchooling-SQL> desc USER_PENDING_CONV_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
USER_PLSQL_OBJECT_SETTINGS: Compiler settings of stored objects
owned by the user
iSelfSchooling-SQL> desc USER_PLSQL_OBJECT_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
PLSQL_OPTIMIZE_LEVEL
NUMBER
PLSQL_CODE_TYPE
VARCHAR2(4000)
PLSQL_DEBUG
VARCHAR2(4000)
PLSQL_WARNINGS
VARCHAR2(4000)
NLS_LENGTH_SEMANTICS
VARCHAR2(4000)
PLSQL_CCFLAGS
VARCHAR2(4000)
USER_POLICIES: All row level security policies for
synonyms, tables, or views owned by the user
iSelfSchooling-SQL> desc USER_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
PF_OWNER
NOT NULL VARCHAR2(30)
PACKAGE
VARCHAR2(30)
FUNCTION
NOT NULL VARCHAR2(30)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
IDX
VARCHAR2(3)
CHK_OPTION
VARCHAR2(3)
ENABLE
VARCHAR2(3)
STATIC_POLICY
VARCHAR2(3)
POLICY_TYPE
VARCHAR2(24)
LONG_PREDICATE
VARCHAR2(3)
USER_POLICY_CONTEXTS: All policy driving context defined for
synonyms, tables, or views in current schema
iSelfSchooling-SQL> desc USER_POLICY_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
NAMESPACE
NOT NULL VARCHAR2(30)
ATTRIBUTE
NOT NULL VARCHAR2(30)
USER_POLICY_GROUPS: All policy groups defined for any
synonym, table, or view
iSelfSchooling-SQL> desc USER_POLICY_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
USER_PROCEDURES: Description of the users own procedures
iSelfSchooling-SQL> desc USER_PROCEDURES;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_PROXIES: Description of connections the user is
allowed to proxy
iSelfSchooling-SQL> desc USER_PROXIES;
Name
Null? Type
----------------------------- -------- --------------------
CLIENT
NOT NULL VARCHAR2(30)
AUTHENTICATION
VARCHAR2(3)
AUTHORIZATION_CONSTRAINT
VARCHAR2(35)
ROLE
VARCHAR2(30)
USER_PUBLISHED_COLUMNS: Source columns available for Change
Data Capture
iSelfSchooling-SQL> desc USER_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)
USER_QUEUES: All queues owned by the user
iSelfSchooling-SQL> desc USER_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_QUEUE_PUBLISHERS
iSelfSchooling-SQL> desc USER_QUEUE_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_QUEUE_SCHEDULES
iSelfSchooling-SQL> desc USER_QUEUE_SCHEDULES;
Name
Null? Type
----------------------------- -------- --------------------
QNAME
VARCHAR2(30)
DESTINATION
VARCHAR2(128)
|