|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_RECYCLEBIN: Description of the Recyclebin view accessible to
the user
iSelfSchooling-SQL> desc DBA_RECYCLEBIN;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
ORIGINAL_NAME
VARCHAR2(32)
OPERATION
VARCHAR2(9)
TYPE
VARCHAR2(25)
TS_NAME
VARCHAR2(30)
CREATETIME
VARCHAR2(19)
DROPTIME
VARCHAR2(19)
DROPSCN
NUMBER
PARTITION_NAME
VARCHAR2(32)
CAN_UNDROP
VARCHAR2(3)
CAN_PURGE
VARCHAR2(3)
RELATED
NOT NULL NUMBER
BASE_OBJECT
NOT
NULL NUMBER
PURGE_OBJECT
NOT NULL NUMBER
SPACE
NUMBER
DBA_REFRESH: All the refresh groups
iSelfSchooling-SQL> desc DBA_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)
DBA_REFRESH_CHILDREN: All the objects in refresh groups
iSelfSchooling-SQL> desc DBA_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)
DBA_REFS: Description of REF columns contained in all tables
iSelfSchooling-SQL> desc DBA_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)
DBA_REGISTERED_ARCHIVED_LOG: Details about the registered log files
iSelfSchooling-SQL> desc DBA_REGISTERED_ARCHIVED_LOG;
Name
Null? Type
----------------------------- -------- --------------------
CONSUMER_NAME
NOT NULL VARCHAR2(30)
SOURCE_DATABASE
VARCHAR2(128)
THREAD#
NOT NULL NUMBER
SEQUENCE#
NOT NULL NUMBER
FIRST_SCN
NOT NULL NUMBER
NEXT_SCN
NUMBER
FIRST_TIME
DATE
NEXT_TIME
DATE
NAME
VARCHAR2(513)
MODIFIED_TIME
DATE
DICTIONARY_BEGIN
VARCHAR2(3)
DICTIONARY_END
VARCHAR2(3)
PURGEABLE
VARCHAR2(3)
RESETLOGS_CHANGE#
NOT NULL NUMBER
RESET_TIMESTAMP
NOT NULL NUMBER
DBA_REGISTERED_MVIEWS: Remote materialized views of local tables
iSelfSchooling-SQL> desc DBA_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
DBA_REGISTERED_MVIEW_GROUPS: Materialized view repgroup registration
information
iSelfSchooling-SQL> desc DBA_REGISTERED_MVIEW_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
MVIEW_SITE
VARCHAR2(128)
GROUP_COMMENT
VARCHAR2(80)
VERSION
VARCHAR2(8)
FNAME
VARCHAR2(30)
OWNER
VARCHAR2(30)
DBA_REGISTERED_SNAPSHOTS: Remote snapshots of local tables
iSelfSchooling-SQL> desc DBA_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
DBA_REGISTERED_SNAPSHOT_GROUPS:
Snapshot
repgroup registration information
iSelfSchooling-SQL> desc DBA_REGISTERED_SNAPSHOT_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
SNAPSHOT_SITE
VARCHAR2(128)
GROUP_COMMENT
VARCHAR2(80)
VERSION
VARCHAR2(8)
FNAME
VARCHAR2(30)
OWNER
VARCHAR2(30)
DBA_REGISTRY
iSelfSchooling-SQL> desc DBA_REGISTRY;
Name
Null? Type
----------------------------- -------- --------------------
COMP_ID
NOT NULL VARCHAR2(30)
COMP_NAME
VARCHAR2(255)
VERSION
VARCHAR2(30)
STATUS
VARCHAR2(11)
MODIFIED
VARCHAR2(20)
NAMESPACE
NOT NULL VARCHAR2(30)
CONTROL
NOT NULL VARCHAR2(30)
SCHEMA
NOT NULL VARCHAR2(30)
PROCEDURE
VARCHAR2(61)
STARTUP
VARCHAR2(8)
PARENT_ID
VARCHAR2(30)
OTHER_SCHEMAS
VARCHAR2(4000)
DBA_REGISTRY_HIERARCHY
iSelfSchooling-SQL> desc DBA_REGISTRY_HIERARCHY;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
NOT NULL VARCHAR2(30)
COMP_ID
VARCHAR2(4000)
VERSION
VARCHAR2(30)
STATUS
VARCHAR2(11)
MODIFIED
VARCHAR2(20)
DBA_REGISTRY_HISTORY
iSelfSchooling-SQL> desc DBA_REGISTRY_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
ACTION_TIME
TIMESTAMP(6)
ACTION
VARCHAR2(30)
NAMESPACE
VARCHAR2(30)
VERSION
VARCHAR2(30)
ID
NUMBER
COMMENTS
VARCHAR2(255)
DBA_REGISTRY_LOG
iSelfSchooling-SQL> desc DBA_REGISTRY_LOG;
Name
Null? Type
----------------------------- -------- --------------------
OPTIME
TIMESTAMP(6)
NAMESPACE
VARCHAR2(30)
COMP_ID
VARCHAR2(30)
OPERATION
VARCHAR2(11)
MESSAGE
VARCHAR2(1000)
DBA_REPAUDIT_ATTRIBUTE: Information about attributes automatically
maintained for replication
iSelfSchooling-SQL> desc DBA_REPAUDIT_ATTRIBUTE;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
DATA_LENGTH |