add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME STATUS PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING BACKED_UP NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES CACHE TABLE_LOCK SAMPLE_SIZE LAST_ANALYZED PARTITIONED IOT_TYPE TEMPORARY SECONDARY NESTED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE ROW_MOVEMENT GLOBAL_STATS USER_STATS DURATION SKIP_CORRUPT MONITORING CLUSTER_OWNER DEPENDENCIES COMPRESSION COMPRESS_FOR DROPPED READ_ONLY SEGMENT_CREATED RESULT_CACHE
SYS DUAL SYSTEM null null VALID 10 40 1 255 16384 1048576 1 2147483645 null 1 1 YES N 1 1 0 0 0 2 0 0          1          1     N ENABLED 1 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS SYSTEM_PRIVILEGE_MAP SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 208 1 0 0 0 26 0 0          1          1     N ENABLED 208 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS TABLE_PRIVILEGE_MAP SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 26 1 0 0 0 11 0 0          1          1     N ENABLED 26 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS STMT_AUDIT_OPTION_MAP SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 270 2 0 0 0 24 0 0          1          1     N ENABLED 270 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS AUDIT_ACTIONS SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 180 1 0 0 0 19 0 0          1          1     N ENABLED 180 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS HS_BULKLOAD_VIEW_OBJ SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 0 0 0 0 0 0 0 0          1          1     N ENABLED 0 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS HS_PARTITION_COL_NAME SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 0 0 0 0 0 0 0 0          1          1     N ENABLED 0 28-AUG-11 NO null N N YES DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS HS_PARTITION_COL_TYPE SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 0 0 0 0 0 0 0 0          1          1     N ENABLED 0 28-AUG-11 NO null N N YES DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYS HS$_PARALLEL_METADATA SYSTEM null null VALID 10 40 1 255 65536 1048576 1 2147483645 null 1 1 YES N 0 0 0 0 0 0 0 0          1          1     N ENABLED 0 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
SYSTEM HELP SYSTEM null null VALID 0 40 1 255 49152 1048576 1 2147483645 null 1 1 YES N 919 7 0 0 0 40 0 0          1          1     N ENABLED 919 28-AUG-11 NO null N N NO DEFAULT DEFAULT DEFAULT DISABLED YES NO null DISABLED YES null DISABLED DISABLED null NO NO YES DEFAULT
OWNER VIEW_NAME
SYS ALL_USERS
SYS ALL_TABLES