|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_EXPORT_OBJECTS: Export INCLUDE and EXCLUDE object type names
iSelfSchooling-SQL> desc DBA_EXPORT_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
HET_TYPE
NOT NULL VARCHAR2(30)
OBJECT_PATH
NOT NULL VARCHAR2(200)
COMMENTS
VARCHAR2(2000)
NAMED
CHAR(1)
DBA_EXP_FILES: Description of export files
iSelfSchooling-SQL> desc DBA_EXP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
EXP_VERSION
NOT NULL NUMBER(3)
EXP_TYPE
VARCHAR2(11)
FILE_NAME
NOT NULL VARCHAR2(100)
USER_NAME
NOT NULL VARCHAR2(30)
TIMESTAMP
NOT NULL DATE
DBA_EXP_OBJECTS: Objects that have been incrementally exported
iSelfSchooling-SQL> desc DBA_EXP_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(13)
CUMULATIVE
DATE
INCREMENTAL
NOT NULL DATE
EXPORT_VERSION
NOT NULL NUMBER(3)
DBA_EXP_VERSION: Version number of the last export session
iSelfSchooling-SQL> desc DBA_EXP_VERSION;
Name
Null? Type
-----------------------------
-------- --------------------
EXP_VERSION
NOT NULL NUMBER(3)
DBA_EXTENTS: Extents comprising all segments in the database
iSelfSchooling-SQL> desc DBA_EXTENTS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
EXTENT_ID
NUMBER
FILE_ID
NUMBER
BLOCK_ID
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
RELATIVE_FNO
NUMBER
DBA_EXTERNAL_LOCATIONS: Description of the external tables locations
accessible to the DBA
iSelfSchooling-SQL> desc DBA_EXTERNAL_LOCATIONS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
LOCATION
VARCHAR2(4000)
DIRECTORY_OWNER
CHAR(3)
DIRECTORY_NAME
VARCHAR2(30)
DBA_EXTERNAL_TABLES: Description of the external tables accessible to
the DBA
iSelfSchooling-SQL> desc DBA_EXTERNAL_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TYPE_OWNER
CHAR(3)
TYPE_NAME
NOT NULL VARCHAR2(30)
DEFAULT_DIRECTORY_OWNER
CHAR(3)
DEFAULT_DIRECTORY_NAME
NOT NULL VARCHAR2(30)
REJECT_LIMIT
VARCHAR2(40)
ACCESS_TYPE
VARCHAR2(7)
ACCESS_PARAMETERS
VARCHAR2(4000)
PROPERTY
VARCHAR2(10)
DBA_FEATURE_USAGE_STATISTICS:
Database
Feature Usage Statistics
iSelfSchooling-SQL> desc DBA_FEATURE_USAGE_STATISTICS;
Name
Null? Type
-----------------------------
-------- --------------------
DBID
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(64)
VERSION
NOT NULL VARCHAR2(17)
DETECTED_USAGES
NOT NULL NUMBER
TOTAL_SAMPLES
NOT NULL NUMBER
CURRENTLY_USED
VARCHAR2(5)
FIRST_USAGE_DATE
DATE
LAST_USAGE_DATE
DATE
AUX_COUNT
NUMBER
FEATURE_INFO
CLOB
LAST_SAMPLE_DATE
DATE
LAST_SAMPLE_PERIOD
NUMBER
SAMPLE_INTERVAL
NUMBER
DESCRIPTION
VARCHAR2(128)
DBA_FGA_AUDIT_TRAIL: All fine grained audit event logs
iSelfSchooling-SQL> desc DBA_FGA_AUDIT_TRAIL;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NOT NULL NUMBER
TIMESTAMP
DATE
DB_USER
VARCHAR2(30)
OS_USER
VARCHAR2(255)
USERHOST
VARCHAR2(128)
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
EXT_NAME
VARCHAR2(4000)
OBJECT_SCHEMA
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(128)
POLICY_NAME
VARCHAR2(30)
SCN
NUMBER
SQL_TEXT
NVARCHAR2(2000)
SQL_BIND
NVARCHAR2(2000)
COMMENT$TEXT
VARCHAR2(4000)
STATEMENT_TYPE
VARCHAR2(7)
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
TRANSACTIONID
RAW(8)
STATEMENTID
NUMBER
ENTRYID
NUMBER
DBA_FILE_GROUPS: Details about file groups
iSelfSchooling-SQL> desc DBA_FILE_GROUPS;
Name
Null? Type
-----------------------------
-------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
KEEP_FILES
NOT NULL VARCHAR2(1)
MIN_VERSIONS
NOT NULL NUMBER
MAX_VERSIONS
NOT NULL NUMBER
RETENTION_DAYS
NOT NULL NUMBER
CREATED
NOT NULL TIMESTAMP(6)
COMMENTS
VARCHAR2(4000)
DEFAULT_DIRECTORY
VARCHAR2(30)
DBA_FILE_GROUP_EXPORT_INFO: Details about export information of file group
versions
iSelfSchooling-SQL> desc DBA_FILE_GROUP_EXPORT_INFO;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
EXPORT_VERSION
NOT NULL VARCHAR2(30)
PLATFORM_NAME
NOT NULL VARCHAR2(101)
EXPORT_TIME
NOT NULL DATE
EXPORT_SCN
NUMBER
SOURCE_GLOBAL_NAME
VARCHAR2(128)
DBA_FILE_GROUP_FILES: Details about file group files
iSelfSchooling-SQL> desc DBA_FILE_GROUP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
FILE_NAME
NOT NULL VARCHAR2(512)
FILE_DIRECTORY
NOT NULL VARCHAR2(30)
FILE_TYPE
VARCHAR2(32)
FILE_SIZE
NUMBER
FILE_BLOCK_SIZE
NUMBER
COMMENTS
VARCHAR2(4000)
DBA_FILE_GROUP_TABLES: Details about the tables in the file group
repository
iSelfSchooling-SQL> desc DBA_FILE_GROUP_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
SCN
NUMBER
DBA_FILE_GROUP_TABLESPACES: Details about the transportable tablespaces in
the file group repository
iSelfSchooling-SQL> desc DBA_FILE_GROUP_TABLESPACES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
TABLESPACE_NAME
NOT
NULL VARCHAR2(30)
DBA_FILE_GROUP_VERSIONS: Details about file group versions
iSelfSchooling-SQL> desc DBA_FILE_GROUP_VERSIONS;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
CREATOR
NOT NULL VARCHAR2(30)
CREATED
NOT NULL TIMESTAMP(6)
COMMENTS
VARCHAR2(4000)
DEFAULT_DIRECTORY
VARCHAR2(30)
DBA_FREE_SPACE: Free extents in all tablespaces
|