ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_REPGROUPED_COLUMN: Columns in the all column groups of
user's replicated tables
iSelfSchooling-SQL> desc USER_REPGROUPED_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
VARCHAR2(30)
GROUP_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
USER_REPGROUP_PRIVILEGES: Information about users who are
registered for object group privileges
iSelfSchooling-SQL> desc USER_REPGROUP_PRIVILEGES;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
NOT NULL VARCHAR2(30)
GNAME
VARCHAR2(30)
CREATED
NOT NULL DATE
RECEIVER
VARCHAR2(1)
PROXY_SNAPADMIN
VARCHAR2(1)
OWNER
VARCHAR2(30)
USER_REPKEY_COLUMNS: Primary columns for a table using
column-level replication
iSelfSchooling-SQL> desc USER_REPKEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
COL
VARCHAR2(4000)
USER_REPOBJECT: Replication information about the current user's objects
iSelfSchooling-SQL> desc USER_REPOBJECT;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
TYPE
VARCHAR2(16)
STATUS
VARCHAR2(10)
GENERATION_STATUS
VARCHAR2(9)
ID
NUMBER
OBJECT_COMMENT
VARCHAR2(80)
GNAME
VARCHAR2(30)
MIN_COMMUNICATION
VARCHAR2(1)
REPLICATION_TRIGGER_EXISTS VARCHAR2(1)
INTERNAL_PACKAGE_EXISTS
VARCHAR2(1)
GROUP_OWNER
VARCHAR2(30)
NESTED_TABLE
VARCHAR2(1)
USER_REPPARAMETER_COLUMN: All columns used for resolving
conflicts in user's replicated tables
iSelfSchooling-SQL> desc USER_REPPARAMETER_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
VARCHAR2(30)
SEQUENCE_NO
NUMBER
METHOD_NAME
VARCHAR2(80)
FUNCTION_NAME
VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
PARAMETER_TABLE_NAME
VARCHAR2(30)
PARAMETER_COLUMN_NAME
VARCHAR2(4000)
PARAMETER_SEQUENCE_NO
NUMBER
USER_REPPRIORITY: Values and their corresponding
priorities in user's priority groups
iSelfSchooling-SQL> desc USER_REPPRIORITY;
Name
Null? Type
----------------------------- -------- --------------------
PRIORITY_GROUP
NOT NULL VARCHAR2(30)
PRIORITY
NOT
NULL NUMBER
DATA_TYPE
VARCHAR2(9)
FIXED_DATA_LENGTH
NUMBER(38)
CHAR_VALUE
CHAR(255)
VARCHAR2_VALUE
VARCHAR2(4000)
NUMBER_VALUE
NUMBER
DATE_VALUE
DATE
RAW_VALUE
RAW(2000)
NCHAR_VALUE
NCHAR(500)
NVARCHAR2_VALUE
NVARCHAR2(1000)
LARGE_CHAR_VALUE
CHAR(2000)
USER_REPPRIORITY_GROUP: Information about user's priority
groups
iSelfSchooling-SQL> desc USER_REPPRIORITY_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
PRIORITY_GROUP
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
FIXED_DATA_LENGTH
NUMBER(38)
PRIORITY_COMMENT
VARCHAR2(80)
USER_REPPROP: Propagation information about the
current user's objects
iSelfSchooling-SQL> desc USER_REPPROP;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(16)
DBLINK
NOT NULL VARCHAR2(128)
HOW
VARCHAR2(13)
PROPAGATE_COMMENT
VARCHAR2(80)
USER_REPRESOLUTION: Description of all conflict resolutions
for users replicated tables
iSelfSchooling-SQL> desc USER_REPRESOLUTION;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
SEQUENCE_NO
NOT NULL NUMBER
METHOD_NAME
NOT NULL VARCHAR2(80)
FUNCTION_NAME
NOT NULL VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
RESOLUTION_COMMENT
VARCHAR2(80)
USER_REPRESOLUTION_METHOD: All conflict resolution methods
accessible to the user
iSelfSchooling-SQL> desc USER_REPRESOLUTION_METHOD;
Name
Null? Type
----------------------------- -------- --------------------
CONFLICT_TYPE
VARCHAR2(10)
METHOD_NAME
NOT NULL VARCHAR2(80)
USER_REPRESOLUTION_STATISTICS: Statistics for conflict resolutions for
user's replicated tables
iSelfSchooling-SQL> desc USER_REPRESOLUTION_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(80)
FUNCTION_NAME
VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
RESOLVED_DATE
NOT NULL DATE
PRIMARY_KEY_VALUE
NOT NULL VARCHAR2(2000)
USER_REPRESOL_STATS_CONTROL: Information about statistics collection
for conflict resolutions for user's replicated tables
iSelfSchooling-SQL> desc USER_REPRESOL_STATS_CONTROL;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
VARCHAR2(9)
STATUS_UPDATE_DATE
NOT NULL DATE
PURGED_DATE
DATE
LAST_PURGE_START_DATE
DATE
LAST_PURGE_END_DATE
DATE
USER_REPSCHEMA: N-way replication information about the
current user
iSelfSchooling-SQL> desc USER_REPSCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT
NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
GNAME
NOT NULL VARCHAR2(30)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
USER_REPSITES: N-way replication information about the
current user
iSelfSchooling-SQL> desc USER_REPSITES;
Name
Null? Type
----------------------------- -------- --------------------
GNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
USER_RESOURCE_LIMITS: Display resource limit of the user
iSelfSchooling-SQL> desc USER_RESOURCE_LIMITS;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
NOT NULL VARCHAR2(32)
LIMIT
VARCHAR2(40)
USER_RESUMABLE: Resumable session information for
current user
iSelfSchooling-SQL> desc USER_RESUMABLE;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
INSTANCE_ID
NUMBER
COORD_INSTANCE_ID
NUMBER
COORD_SESSION_ID
NUMBER
STATUS
VARCHAR2(9)
TIMEOUT
NUMBER
START_TIME
VARCHAR2(20)
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
SQL_TEXT
VARCHAR2(1000)
ERROR_NUMBER
NUMBER
ERROR_PARAMETER1
VARCHAR2(80)
ERROR_PARAMETER2
VARCHAR2(80)
ERROR_PARAMETER3
VARCHAR2(80)
ERROR_PARAMETER4
VARCHAR2(80)
ERROR_PARAMETER5
VARCHAR2(80)
ERROR_MSG
VARCHAR2(4000)
USER_REWRITE_EQUIVALENCES: Description of all rewrite equivalence
owned by the user
iSelfSchooling-SQL> desc USER_REWRITE_EQUIVALENCES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
SOURCE_STMT
CLOB
DESTINATION_STMT
CLOB
REWRITE_MODE
VARCHAR2(10)
USER_ROLE_PRIVS: Roles granted to current user
iSelfSchooling-SQL> desc USER_ROLE_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
GRANTED_ROLE
VARCHAR2(30)
ADMIN_OPTION
VARCHAR2(3)
DEFAULT_ROLE
VARCHAR2(3)
OS_GRANTED
VARCHAR2(3)
USER_RSRC_CONSUMER_GROUP_PRIVS: Switch privileges for consumer groups
for the user
iSelfSchooling-SQL> desc USER_RSRC_CONSUMER_GROUP_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTED_GROUP
VARCHAR2(30)
GRANT_OPTION
VARCHAR2(3)
INITIAL_GROUP
VARCHAR2(3)
USER_RSRC_MANAGER_SYSTEM_PRIVS: system privileges for the resource
manager for the user
iSelfSchooling-SQL> desc USER_RSRC_MANAGER_SYSTEM_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
PRIVILEGE
NOT NULL VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(3)
USER_RULES: Rules owned by the user
iSelfSchooling-SQL> desc USER_RULES;
Name
Null? Type
----------------------------- -------- --------------------
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_CONDITION
CLOB
RULE_EVALUATION_CONTEXT_OWNER VARCHAR2(30)
RULE_EVALUATION_CONTEXT_NAME VARCHAR2(30)
RULE_ACTION_CONTEXT
RE$NV_LIST
RULE_COMMENT
VARCHAR2(4000)
USER_RULESETS: Rulesets owned by the user: maintained
for backward compatibility
iSelfSchooling-SQL> desc USER_RULESETS;
Name
Null? Type
----------------------------- -------- --------------------
RULESET_NAME
NOT NULL VARCHAR2(30)
RULESET_STORAGE_TABLE
VARCHAR2
BASE_TABLE
VARCHAR2(61)
RULESET_COMMENT
VARCHAR2(4000)
USER_RULE_SETS: Rule sets owned by the user
iSelfSchooling-SQL> desc USER_RULE_SETS;
Name
Null? Type
----------------------------- -------- --------------------
RULE_SET_NAME
NOT NULL VARCHAR2(30)
RULE_SET_EVAL_CONTEXT_OWNER VARCHAR2(30)
RULE_SET_EVAL_CONTEXT_NAME VARCHAR2(30)
RULE_SET_COMMENT
VARCHAR2(4000)
USER_RULE_SET_RULES: Rules in user rule sets
iSelfSchooling-SQL> desc USER_RULE_SET_RULES;
Name
Null? Type
----------------------------- -------- --------------------
RULE_SET_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_SET_RULE_ENABLED
VARCHAR2(8)
RULE_SET_RULE_EVAL_CTX_OWNER VARCHAR2(30)
RULE_SET_RULE_EVAL_CTX_NAME VARCHAR2(30)
RULE_SET_RULE_COMMENT
VARCHAR2(4000)
USER_SCHEDULER_CHAINS: All scheduler chains owned by the
current user
iSelfSchooling-SQL> desc USER_SCHEDULER_CHAINS;
Name
Null?
Type
----------------------------- -------- --------------------
CHAIN_NAME
NOT NULL VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
NUMBER_OF_RULES
NUMBER
NUMBER_OF_STEPS
NUMBER
ENABLED
VARCHAR2(5)
EVALUATION_INTERVAL
INTERVAL DAY(3)
USER_RULE_SET
VARCHAR2(5)
COMMENTS
VARCHAR2(240)
USER_SCHEDULER_CHAIN_RULES: All rules from scheduler chains owned
by the current user
iSelfSchooling-SQL> desc USER_SCHEDULER_CHAIN_RULES;
Name
Null? Type
----------------------------- -------- --------------------
CHAIN_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
CONDITION
VARCHAR2(4000)
ACTION
VARCHAR2(4000)
COMMENTS
VARCHAR2(4000)
USER_SCHEDULER_CHAIN_STEPS: All steps of scheduler chains owned by
the current user
iSelfSchooling-SQL> desc USER_SCHEDULER_CHAIN_STEPS;
Name
Null?
Type
----------------------------- -------- --------------------
CHAIN_NAME
NOT NULL VARCHAR2(30)
STEP_NAME
NOT NULL VARCHAR2(30)
PROGRAM_OWNER
VARCHAR2(98)
PROGRAM_NAME
VARCHAR2(98)
EVENT_SCHEDULE_OWNER
VARCHAR2(98)
EVENT_SCHEDULE_NAME
VARCHAR2(98)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
SKIP
VARCHAR2(5)
PAUSE
VARCHAR2(5)
RESTART_ON_RECOVERY
VARCHAR2(5)
STEP_TYPE
VARCHAR2(14)
TIMEOUT
INTERVAL DAY(3)
USER_SCHEDULER_JOBS: All scheduler jobs in the database
iSelfSchooling-SQL> desc USER_SCHEDULER_JOBS;
Name
Null?
Type
----------------------------- -------- --------------------
JOB_NAME
NOT NULL VARCHAR2(30)
JOB_SUBNAME
VARCHAR2(30)
JOB_CREATOR
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
PROGRAM_OWNER
VARCHAR2(4000)
PROGRAM_NAME
VARCHAR2(4000)
JOB_TYPE
VARCHAR2(16)
JOB_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
SCHEDULE_OWNER
VARCHAR2(4000)
SCHEDULE_NAME
VARCHAR2(4000)
SCHEDULE_TYPE
VARCHAR2(12)
START_DATE
TIMESTAMP(6)
REPEAT_INTERVAL
VARCHAR2(4000)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
EVENT_RULE
VARCHAR2(65)
END_DATE
TIMESTAMP(6)
JOB_CLASS
VARCHAR2(30)
ENABLED
VARCHAR2(5)
AUTO_DROP
VARCHAR2(5)
RESTARTABLE
VARCHAR2(5)
STATE
VARCHAR2(15)
JOB_PRIORITY
NUMBER
RUN_COUNT
NUMBER
MAX_RUNS
NUMBER
FAILURE_COUNT
NUMBER
MAX_FAILURES
NUMBER
RETRY_COUNT
NUMBER
LAST_START_DATE
TIMESTAMP(6)
LAST_RUN_DURATION
INTERVAL DAY(9)
NEXT_RUN_DATE
TIMESTAMP(6)
SCHEDULE_LIMIT
INTERVAL DAY(3)
MAX_RUN_DURATION
INTERVAL DAY(3)
LOGGING_LEVEL
VARCHAR2(4)
STOP_ON_WINDOW_CLOSE
VARCHAR2(5)
INSTANCE_STICKINESS
VARCHAR2(5)
RAISE_EVENTS
VARCHAR2(4000)
SYSTEM
VARCHAR2(5)
JOB_WEIGHT
NUMBER
NLS_ENV
VARCHAR2(4000)
SOURCE
VARCHAR2(128)
DESTINATION
VARCHAR2(128)
COMMENTS
VARCHAR2(240)
FLAGS
NUMBER
USER_SCHEDULER_JOB_ARGS: All arguments with set values of all
scheduler jobs in the database
iSelfSchooling-SQL> desc USER_SCHEDULER_JOB_ARGS;
Name
Null? Type
----------------------------- -------- --------------------
JOB_NAME
NOT NULL VARCHAR2(30)
ARGUMENT_NAME
VARCHAR2(30)
ARGUMENT_POSITION
NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
VALUE
VARCHAR2(4000)
ANYDATA_VALUE
ANYDATA
OUT_ARGUMENT
VARCHAR2(5)
USER_SCHEDULER_JOB_LOG: Logged information for all scheduler
jobs
iSelfSchooling-SQL> desc USER_SCHEDULER_JOB_LOG;
Name Null?
Type
----------------------------- -------- --------------------
LOG_ID
NOT NULL NUMBER
LOG_DATE
TIMESTAMP(6)
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(65)
JOB_SUBNAME
VARCHAR2(65)
JOB_CLASS
VARCHAR2(30)
OPERATION
VARCHAR2(30)
STATUS
VARCHAR2(30)
USER_NAME
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
ADDITIONAL_INFO
CLOB
USER_SCHEDULER_JOB_RUN_DETAILS: The details of a job run
iSelfSchooling-SQL> desc USER_SCHEDULER_JOB_RUN_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
LOG_DATE
TIMESTAMP(6)
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(65)
JOB_SUBNAME
VARCHAR2(65)
STATUS
VARCHAR2(30)
ERROR#
NUMBER
REQ_START_DATE
TIMESTAMP(6)
ACTUAL_START_DATE
TIMESTAMP(6)
RUN_DURATION
INTERVAL DAY(3)
INSTANCE_ID
NUMBER
SESSION_ID
VARCHAR2(30)
SLAVE_PID
VARCHAR2(30)
CPU_USED
INTERVAL DAY(3)
ADDITIONAL_INFO
VARCHAR2(4000)
USER_SCHEDULER_PROGRAMS: Scheduler programs owned by the current
user
iSelfSchooling-SQL> desc USER_SCHEDULER_PROGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
PROGRAM_NAME
NOT NULL VARCHAR2(30)
PROGRAM_TYPE
VARCHAR2(16)
PROGRAM_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
ENABLED
VARCHAR2(5)
DETACHED
VARCHAR2(5)
COMMENTS
VARCHAR2(240)
USER_SCHEDULER_PROGRAM_ARGS: All arguments of all scheduler programs
in the database
iSelfSchooling-SQL> desc USER_SCHEDULER_PROGRAM_ARGS;
Name
Null? Type
----------------------------- -------- --------------------
PROGRAM_NAME
NOT NULL VARCHAR2(30)
ARGUMENT_NAME
VARCHAR2(30)
ARGUMENT_POSITION
NOT NULL NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
METADATA_ATTRIBUTE
VARCHAR2(12)
DEFAULT_VALUE
VARCHAR2(4000)
DEFAULT_ANYDATA_VALUE
ANYDATA
OUT_ARGUMENT
VARCHAR2(5)
USER_SCHEDULER_RUNNING_CHAINS: All steps of chains being run by jobs owned
by the current user
iSelfSchooling-SQL> desc
USER_SCHEDULER_RUNNING_CHAINS;
Name
Null? Type
----------------------------- -------- --------------------
JOB_NAME
VARCHAR2(30)
JOB_SUBNAME
VARCHAR2(30)
CHAIN_OWNER
VARCHAR2(30)
CHAIN_NAME
VARCHAR2(30)
STEP_NAME
VARCHAR2(30)
STATE
VARCHAR2(11)
ERROR_CODE
NUMBER
COMPLETED
VARCHAR2(5)
START_DATE
TIMESTAMP(6)
END_DATE
TIMESTAMP(6)
DURATION
INTERVAL DAY(9)
SKIP
VARCHAR2(5)
PAUSE
VARCHAR2(5)
RESTART_ON_RECOVERY
VARCHAR2(5)
STEP_JOB_SUBNAME
VARCHAR2(30)
STEP_JOB_LOG_ID
NUMBER
USER_SCHEDULER_SCHEDULES: Schedules belonging to the current user
iSelfSchooling-SQL> desc USER_SCHEDULER_SCHEDULES;
Name
Null? Type
----------------------------- -------- --------------------
SCHEDULE_NAME
NOT NULL VARCHAR2(30)
SCHEDULE_TYPE
VARCHAR2(8)
START_DATE
TIMESTAMP(6)
REPEAT_INTERVAL
VARCHAR2(4000)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(30)
EVENT_CONDITION
VARCHAR2(4000)
END_DATE
TIMESTAMP(6)
COMMENTS
VARCHAR2(240)
USER_SECONDARY_OBJECTS: All secondary objects for domain
indexes
iSelfSchooling-SQL> desc USER_SECONDARY_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_OWNER
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_NAME
NOT NULL VARCHAR2(30)
USER_SEC_RELEVANT_COLS: Security Relevant columns of VPD
policies for tables or views owned by the user
iSelfSchooling-SQL> desc USER_SEC_RELEVANT_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
VARCHAR2(30)
POLICY_GROUP
VARCHAR2(30)
POLICY_NAME
VARCHAR2(30)
SEC_REL_COLUMN
VARCHAR2(30)
COLUMN_OPTION
VARCHAR2(8)
USER_SEGMENTS: Storage allocated for all database
segments
iSelfSchooling-SQL> desc USER_SEGMENTS;
Name
Null? Type
----------------------------- -------- --------------------
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
BYTES
NUMBER
BLOCKS
NUMBER
EXTENTS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
BUFFER_POOL
VARCHAR2(7)
|