|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_CAPTURE_EXTRA_ATTRIBUTES:
Extra
attributes for a capture process
iSelfSchooling-SQL> desc DBA_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)
DBA_CAPTURE_PARAMETERS: All parameters for capture process
iSelfSchooling-SQL> desc DBA_CAPTURE_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
CAPTURE_NAME
NOT NULL VARCHAR2(30)
PARAMETER
NOT NULL VARCHAR2(128)
VALUE
VARCHAR2(4000)
SET_BY_USER
VARCHAR2(3)
DBA_CAPTURE_PREPARED_DATABASE:
Is
the local database prepared for instantiation?
iSelfSchooling-SQL> desc DBA_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)
DBA_CAPTURE_PREPARED_SCHEMAS:
All
schemas at the local database that are prepared for instantiation
iSelfSchooling-SQL> desc DBA_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)
DBA_CAPTURE_PREPARED_TABLES: All tables prepared for instantiation
iSelfSchooling-SQL> desc DBA_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)
DBA_CATALOG: All database Tables, Views, Synonyms, Sequences
iSelfSchooling-SQL> desc DBA_CATALOG;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
DBA_CHANGE_NOTIFICATION_REGS:
Description
of the registrations for change notification
iSelfSchooling-SQL> desc DBA_CHANGE_NOTIFICATION_REGS;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(31)
REGID
NUMBER
REGFLAGS
NUMBER
CALLBACK
VARCHAR2(256)
OPERATIONS_FILTER
NUMBER
CHANGELAG
NUMBER
TIMEOUT
NUMBER
TABLE_NAME
VARCHAR2(63)
DBA_CLUSTERS: Description of all clusters in the database
iSelfSchooling-SQL> desc DBA_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)
DBA_CLUSTER_HASH_EXPRESSIONS:
Hash
functions for all clusters
iSelfSchooling-SQL> desc DBA_CLUSTER_HASH_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CLUSTER_NAME
NOT NULL VARCHAR2(30)
HASH_EXPRESSION
LONG
DBA_CLU_COLUMNS: Mapping of table columns to cluster columns
iSelfSchooling-SQL> desc DBA_CLU_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CLUSTER_NAME
NOT NULL VARCHAR2(30)
CLU_COLUMN_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT
NULL VARCHAR2(30)
TAB_COLUMN_NAME
VARCHAR2(4000)
DBA_COLL_TYPES: Description of all named collection types in the
database
iSelfSchooling-SQL> desc DBA_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)
DBA_COL_COMMENTS: Comments on columns of all tables and views
iSelfSchooling-SQL> desc DBA_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)
DBA_COL_PRIVS: All grants on columns in the database
iSelfSchooling-SQL> desc DBA_COL_PRIVS;
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)
DBA_COMMON_AUDIT_TRAIL: Combined Standard and Fine Grained audit trail
entries
iSelfSchooling-SQL> desc DBA_COMMON_AUDIT_TRAIL;
Name
Null? Type
----------------------------- -------- --------------------
AUDIT_TYPE
VARCHAR2(22)
SESSION_ID
NUMBER
PROXY_SESSIONID
NUMBER
STATEMENTID
NUMBER
ENTRYID
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
GLOBAL_UID
VARCHAR2(32)
DB_USER
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
EXT_NAME
VARCHAR2(4000)
OS_USER
VARCHAR2(255)
USERHOST
VARCHAR2(128)
OS_PROCESS
VARCHAR2(16)
TERMINAL
VARCHAR2(255)
INSTANCE_NUMBER
NUMBER
OBJECT_SCHEMA
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(128)
POLICY_NAME
VARCHAR2(30)
NEW_OWNER
VARCHAR2(30)
NEW_NAME
VARCHAR2(128)
ACTION
NUMBER
STATEMENT_TYPE
VARCHAR2(28)
AUDIT_OPTION
VARCHAR2(40)
TRANSACTIONID
RAW(8)
RETURNCODE
NUMBER
SCN
NUMBER
COMMENT_TEXT
VARCHAR2(4000)
SQL_BIND
NVARCHAR2(2000)
SQL_TEXT
NVARCHAR2(2000)
OBJ_PRIVILEGE
VARCHAR2(16)
SYS_PRIVILEGE
VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(1)
OS_PRIVILEGE
VARCHAR2(7)
GRANTEE
VARCHAR2(30)
PRIV_USED
VARCHAR2(40)
SES_ACTIONS
VARCHAR2(19)
LOGOFF_TIME
DATE
LOGOFF_LREAD
NUMBER
LOGOFF_PREAD
NUMBER
LOGOFF_LWRITE
NUMBER
LOGOFF_DLOCK
VARCHAR2(40)
SESSION_CPU
NUMBER
DBA_CONNECT_ROLE_GRANTEES: Information regarding which users are granted
CONNECT
iSelfSchooling-SQL> desc DBA_CONNECT_ROLE_GRANTEES;
Name
Null? Type
-----------------------------
-------- --------------------
GRANTEE
VARCHAR2(30)
PATH_OF_CONNECT_ROLE_GRANT VARCHAR2(4000)
ADMIN_OPT
VARCHAR2(3)
DBA_CONSTRAINTS: Constraint definitions on all tables
iSelfSchooling-SQL> desc DBA_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)
DBA_CONS_COLUMNS: Information about accessible columns in
constraint definitions
iSelfSchooling-SQL> desc DBA_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
DBA_CONS_OBJ_COLUMNS: List of types an object column or attribute is
constrained to in all tables in the database
iSelfSchooling-SQL> desc DBA_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)
DBA_CONTEXT: Description of all context namespace information
iSelfSchooling-SQL> desc DBA_CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
NOT NULL VARCHAR2(30)
SCHEMA
NOT NULL
VARCHAR2(30)
PACKAGE
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(22)
DBA_CPU_USAGE_STATISTICS: Database CPU Usage Statistics
iSelfSchooling-SQL> desc DBA_CPU_USAGE_STATISTICS;
Name
Null?
Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
VERSION
NOT NULL VARCHAR2(17)
TIMESTAMP
NOT NULL DATE
CPU_COUNT
NUMBER
CPU_CORE_COUNT
NUMBER
CPU_SOCKET_COUNT
NUMBER
DBA_DATAPUMP_JOBS: Datapump jobs
iSelfSchooling-SQL> desc DBA_DATAPUMP_JOBS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER_NAME
VARCHAR2(30)
JOB_NAME
VARCHAR2(30)
OPERATION
VARCHAR2(30)
JOB_MODE
VARCHAR2(30)
STATE
VARCHAR2(30)
DEGREE
NUMBER
ATTACHED_SESSIONS
NUMBER
DATAPUMP_SESSIONS
NUMBER
DBA_DATAPUMP_SESSIONS: Datapump sessions attached to a job
iSelfSchooling-SQL> desc DBA_DATAPUMP_SESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER_NAME
VARCHAR2(30)
JOB_NAME
VARCHAR2(30)
SADDR
RAW(8)
SESSION_TYPE
VARCHAR2(14)
DBA_DATA_FILES: Information about database data files
iSelfSchooling-SQL> desc DBA_DATA_FILES;
Name
Null? Type
-----------------------------
-------- --------------------
FILE_NAME
VARCHAR2(513)
FILE_ID
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
BYTES
NUMBER
BLOCKS
NUMBER
STATUS
VARCHAR2(9)
RELATIVE_FNO
NUMBER
AUTOEXTENSIBLE
VARCHAR2(3)
MAXBYTES
NUMBER
MAXBLOCKS
NUMBER
INCREMENT_BY
NUMBER
USER_BYTES
NUMBER
USER_BLOCKS
NUMBER
ONLINE_STATUS
VARCHAR2(7)
DBA_DB_LINKS: All database links in the database
iSelfSchooling-SQL> desc DBA_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
DBA_DDL_LOCKS
iSelfSchooling-SQL> desc DBA_DDL_LOCKS;
Name
Null?
Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
TYPE
VARCHAR2(40)
MODE_HELD
VARCHAR2(9)
MODE_REQUESTED
VARCHAR2(9)
DBA_DEPENDENCIES: Dependencies to and from objects
iSelfSchooling-SQL> desc DBA_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)
DBA_DIMENSIONS: Description of the dimension objects accessible
to the DBA
iSelfSchooling-SQL> desc DBA_DIMENSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
INVALID
VARCHAR2(1)
COMPILE_STATE
VARCHAR2(13)
REVISION
NUMBER
DBA_DIM_ATTRIBUTES: Representation of the relationship between a
dimension level and a functionally dependent column
iSelfSchooling-SQL> desc DBA_DIM_ATTRIBUTES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
ATTRIBUTE_NAME
VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
INFERRED
CHAR(1)
DBA_DIM_CHILD_OF: Representaion of a 1:n hierarchical relationship
between a pair of levels in a dimension
iSelfSchooling-SQL> desc DBA_DIM_CHILD_OF;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
HIERARCHY_NAME
VARCHAR2(30)
POSITION
NOT NULL NUMBER
CHILD_LEVEL_NAME
VARCHAR2(30)
JOIN_KEY_ID
VARCHAR2(40)
PARENT_LEVEL_NAME
VARCHAR2(30)
DBA_DIM_HIERARCHIES: Representation of a dimension hierarchy
iSelfSchooling-SQL> desc DBA_DIM_HIERARCHIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
HIERARCHY_NAME
VARCHAR2(30)
DBA_DIM_JOIN_KEY: Representation of a join between two dimension
tables.
iSelfSchooling-SQL> desc DBA_DIM_JOIN_KEY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
DIM_KEY_ID
NOT NULL NUMBER
LEVEL_NAME
VARCHAR2(30)
KEY_POSITION
NOT NULL NUMBER
HIERARCHY_NAME
VARCHAR2(30)
CHILD_JOIN_OWNER
NOT NULL VARCHAR2(30)
CHILD_JOIN_TABLE
NOT NULL VARCHAR2(30)
CHILD_JOIN_COLUMN
NOT NULL VARCHAR2(30)
CHILD_LEVEL_NAME
VARCHAR2(30)
DBA_DIM_LEVELS: Description of dimension levels visible to DBA
iSelfSchooling-SQL> desc DBA_DIM_LEVELS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
NUM_COLUMNS
NUMBER
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
SKIP_WHEN_NULL
VARCHAR2(1)
DBA_DIM_LEVEL_KEY: Representations of columns of a dimension level
iSelfSchooling-SQL> desc DBA_DIM_LEVEL_KEY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
KEY_POSITION
NOT NULL NUMBER
COLUMN_NAME
NOT NULL VARCHAR2(30)
DBA_DIRECTORIES: Description of all directories
iSelfSchooling-SQL> desc DBA_DIRECTORIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIRECTORY_NAME
NOT NULL VARCHAR2(30)
DIRECTORY_PATH
VARCHAR2(4000)
DBA_DML_LOCKS
iSelfSchooling-SQL> desc DBA_DML_LOCKS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MODE_HELD
VARCHAR2(13)
MODE_REQUESTED
VARCHAR2(13)
LAST_CONVERT
NUMBER
BLOCKING_OTHERS
VARCHAR2(40)
DBA_DMT_FREE_SPACE: Free extents in all dictionary managed
tablespaces
iSelfSchooling-SQL> desc DBA_DMT_FREE_SPACE;
Name
Null?
Type
----------------------------- -------- --------------------
TABLESPACE_ID
NOT NULL NUMBER
FILE_ID
NOT NULL NUMBER
BLOCK_ID
NOT NULL NUMBER
BLOCKS
NOT
NULL NUMBER
DBA_DMT_USED_EXTENTS: All extents in the dictionary managed
tablespaces
iSelfSchooling-SQL> desc DBA_DMT_USED_EXTENTS;
Name
Null? Type
----------------------------- -------- --------------------
SEGMENT_FILEID
NOT NULL NUMBER
SEGMENT_BLOCK
NOT NULL NUMBER
TABLESPACE_ID
NOT NULL NUMBER
EXTENT_ID
NOT NULL NUMBER
FILEID
NOT NULL NUMBER
BLOCK
NOT NULL
NUMBER
LENGTH
NOT NULL NUMBER
DBA_ENABLED_AGGREGATIONS: Information about enabled on-demand statistic
aggregation
iSelfSchooling-SQL> desc DBA_ENABLED_AGGREGATIONS;
Name
Null? Type
-----------------------------
-------- --------------------
AGGREGATION_TYPE
VARCHAR2(21)
PRIMARY_ID
VARCHAR2(64)
QUALIFIER_ID1
VARCHAR2(48)
QUALIFIER_ID2
VARCHAR2(32)
DBA_ENABLED_TRACES: Information about enabled SQL traces
iSelfSchooling-SQL> desc DBA_ENABLED_TRACES;
Name
Null? Type
----------------------------- -------- --------------------
TRACE_TYPE
VARCHAR2(21)
PRIMARY_ID
VARCHAR2(64)
QUALIFIER_ID1
VARCHAR2(48)
QUALIFIER_ID2
VARCHAR2(32)
WAITS
VARCHAR2(5)
BINDS
VARCHAR2(5)
INSTANCE_NAME
VARCHAR2(16)
DBA_ENCRYPTED_COLUMNS: Encryption information on columns in the
database
iSelfSchooling-SQL> desc DBA_ENCRYPTED_COLUMNS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
ENCRYPTION_ALG
VARCHAR2(29)
SALT
VARCHAR2(3)
DBA_EPG_DAD_AUTHORIZATION: DADs authorized to use different user's
privileges
iSelfSchooling-SQL> desc DBA_EPG_DAD_AUTHORIZATION;
Name
Null? Type
-----------------------------
-------- --------------------
DAD_NAME
NOT NULL VARCHAR2(64)
USERNAME
NOT NULL VARCHAR2(30)
DBA_ERRORS: Current errors on all stored objects in the
database
iSelfSchooling-SQL> desc DBA_ERRORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
SEQUENCE
NOT NULL NUMBER
LINE
NOT NULL NUMBER
POSITION
NOT NULL NUMBER
TEXT
NOT NULL VARCHAR2(4000)
ATTRIBUTE
VARCHAR2(9)
MESSAGE_NUMBER
NUMBER
DBA_EVALUATION_CONTEXTS: rule evaluation contexts in the database
iSelfSchooling-SQL> desc DBA_EVALUATION_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
EVALUATION_FUNCTION
VARCHAR2(4000)
EVALUATION_CONTEXT_COMMENT VARCHAR2(4000)
DBA_EVALUATION_CONTEXT_TABLES:
tables
in all rule evaluation contexts in the database
iSelfSchooling-SQL> desc DBA_EVALUATION_CONTEXT_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
TABLE_ALIAS
VARCHAR2(30)
TABLE_NAME
VARCHAR2(4000)
DBA_EVALUATION_CONTEXT_VARS: variables in all rule evaluation contexts in the
database
iSelfSchooling-SQL> desc DBA_EVALUATION_CONTEXT_VARS;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
VARIABLE_NAME
VARCHAR2(30)
VARIABLE_TYPE
VARCHAR2(4000)
VARIABLE_VALUE_FUNCTION
VARCHAR2(4000)
VARIABLE_METHOD_FUNCTION
VARCHAR2(228)
|
