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”
| Column | Datatype | Description |
|---|---|---|
|
|
|
Record ID |
|
|
|
Record stamp |
|
|
|
Datafile number |
|
|
|
SCN at which offlined |
|
|
|
SCN at which onlined |
|
|
|
Time of offline SCN |
|
|
|
Resetlogs change number of the record |
|
|
|
Resetlogs timestamp of the record |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
