Oracle表有占用空间表无数据,问什么我的一个表中没有数据，却占了20G的空间

最新推荐文章于 2022-05-17 17:43:30 发布

CN队长

最新推荐文章于 2022-05-17 17:43:30 发布

阅读量1.2k

点赞数

文章标签： Oracle表有占用空间表无数据

SQL查询 MMS_BACKUP 表空间扩展缓存

关键词由CSDN通过智能技术生成

最初由 linlams 发布

[B]select * from user_tables where table_name='MMS_BACKUP';

TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME 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 ROW_MOVEMENT GLOBAL_STATS USER_STATS DURATION SKIP_CORRUPT MONITORING CLUSTER_OWNER DEPENDENCIES COMPRESSION

------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------- --------- -------- ---------- ------------ ---------- --------- ----------- ------------------------- ------------------- -------------------- -------------------- ---------- ---------- ----------- ------------- ----------- ------------ --------- --------- ------ ----------- ------------ ------------ ---------- --------------- ------------ ---------- ------------------------------ ------------ -----------

MMS_BACKUP MMS 10 40 1 255 67584 1 2147483645 1 1 NO N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED DISABLED [/B]