|
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)
|