Oracle 视图 V$OFFLINE_RANGE 官方解释，作用，如何使用详细说明

本站中文解释

V$OFFLINE_RANGE是一个视图，用于报告数据表、分区和子分区的存储空间状态，可以和V$FILESEGMENT表一起报告每个数据表及其对于的存储空间状态。该视图是只读的，接受3个参数：表名，分区名和子分区名。

使用视图 V$OFFLINE_RANGE时，首先需要确定要查询的表，然后再确定查询表的分区和子分区。最后，使用SELECT语句查询表、分区和子分区的存储空间状态，方法如下：

SELECT segment_name, partition_name, subpartition_name, offline_status FROM V$OFFLINE_RANGE WHERE segment_name=’表名’ [AND partition_name=’分区名’] [AND subpartition_name=’子分区名’];

官方英文解释

V$OFFLINE_RANGE displays datafile offline information from the control file.

Note that the last offline range of each datafile is kept in the DATAFILE record.

An offline range is created for a datafile when its tablespace is first altered to be OFFLINE NORMAL or READ ONLY, and then subsequently altered to be ONLINE or read/write. Note that no offline range is created if the datafile itself is altered to be OFFLINE or if the tablespace is altered to be OFFLINE IMMEDIATE.

See Also:

“V$DATAFILE”