表分区视图-引用
查询下列与Oracle兼容的目录视图来回顾分区表的详细信息。
ALL PART TABLES
下面的表列出了可在视图ALL_PART_TABLES中得到的信息
Column | Type | Description |
---|---|---|
owner | name | The owner of the table. |
table name | name | The name of the table. |
schema name | name | Tlie sche ma in which the table resides. |
partitioning type | text | RANGE o r LIST |
subpartitioning type | text | RANGE, LIh T, or NONE |
partition count | bigint | The numb er of partitions. |
def subpartition count | integer | The default subpartition count - this will always be 0. |
partitioning key count | integer | The numb er of columns listed in the partition by clause. |
subpartitioning key count | integer | The numb er of columns in the subpartition by clause. |
status | character varying(8) | Provided for Oracle Compatibility - this column will always be VALID. |
def_tablespace_name | character varying(30) | Provided for Oracle Compatibility - this column will always be NULL. |
def_pct_free | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def pct used | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def_ini_trans | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def max trans | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def_initial_extent | character varying(4 0) | Provided for Oracle Compatibility - this column will always be NULL. |
def_next_extent | character varying(4 0) | Provided for Oracle Compatibility - this column will always be NULL. |
def min extents | character varying(4 0) | Provided for Oracle Compatibility - this column will always be NULL. |
def max extents | character varying(4 0) | Provided for Oracle Compatibility - this column will always be NULL. |
def_pct_increase | character varying(4 0) | Provided for Oracle Compatibility - this column will always be NULL. |
def_freelists | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def freelist groups | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
def_logging | character varying(7) | Provided for Oracle Compatibility - this column will always be YES |
def compression | character varying(8) | Provided for Oracle Compatibility - this column will always be NONE |
def buffer pool | character varying(7) | Provided for Oracle Compatibility - this column will always be DEFAULT |
ref ptn constraint name | character varying(30) | Provided for Oracle Compatibility - this column will always be NULL |
interval | character varying(1000) | Provided for Oracle Compatibility - this column will always be NULL |
ALL_TAB_PARTITIONS
下面的表列出了可在视图ALL_TAB_PARTITIONS中得到的信息。
Column | Type | Description |
---|---|---|
table owner | name | The owner of the table. |
table name | name | The name of the table. |
schema name | name | Tlie sche ma in which the table resides. |
composite | text | YE S if tlie tab le is subpartioned; NO if it is not subpartitioned. |
partition name | name | The name of the partition. |
subpartition count | bigint | The numb er of subpartitions for this partition. |
high_value | text | The partitio n limit for RANGE partitions, or the partition value for LIST partitions. |
high value length | integer | The le ngth of high value. |
partition position | integer | The o rdinal po sitih n of this partition. |
tablespace name | name | The tab le spac e in which this partition resides. |
pct_free | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
pct_used | numeric | P rovided fo r Ohac le Compatibility - this column will always be 0. |
ini_trans | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
max trans | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
initial_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
next_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
min_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
max_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
pct_increase | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
freelists | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
freelist_groups | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
logging | character varying(7) | Provided for Oracle Compatibility - this c o lumn will always be YES. |
compression | character varying(8) | Provided for Oracle Compatibility - this c o lumn will always be NONE. |
num rows | numeric | The ahpro x. numb er of rows in this partition. |
blocks | integer | Th a^ro x. numb er of blocks in this partition. |
empty blocks | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
avg space | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
chain_cnt | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
avg row len | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
sample size | numeric | P rovided fo r Oracle Compatibility - this column will always be NULL. |
last analyzed | timestamp without time zone | Provided for Oracle Compatibility - this column will always be NULL. |
buffer_pool | character varying(7) | Provided for Oracle Compatibility - this c o lumn will always be NULL. |
global_stats | character varying(3) | Provided for Oracle Compatibility - this c o lumn will always be YES. |
user_stats | character varying(3) | Provided for Oracle Compatibility - this c o lumn will always be NO. |
backing table | regclass | OID of the b acking table for this partition. |
server name | name | The name of the server on which the partition resides. |
ALL TAB SUBPARTITIONS
下面的表列出了可在视图ALL_TAB_SUBPARTITIONS中得到的信息。
Column | Type | Description |
---|---|---|
table owner | name | Tte narne of the owner of the table. |
table name | name | Tte narne of the table. |
schema_name | name | Tfe narne of the schema in which the table resides. |
partition name | name | Tte narne of the partition. |
high value | text | Tfe subpartitio n lfmit for RANGE subpartitions, or the subpartition value for LIST subpartitions. |
high value length | integer | Tte le ngtlrn of high value. |
subpartition name | name | Tte narne of the subpartition. |
subpartition position | integer | Tte o rdinal po sitif n of this subpartition. |
tablespace_name | name | Tte tab k spac e in which this subpartition resides. |
pct_free | numeric | P rovided fo r Ornacle Compatibility - this column will always be 0. |
pct used | numeric | P rovided fo r Ornacle Compatibility - this column will always be 0. |
ini_trans | numeric | P rovided fo r Ornacle Compatibility - this column will always be 0. |
max trans | numeric | P rovided fo r Ornacle Compatibility - this column will always be 0. |
initial extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
next_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
min_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
max_extent | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
pct increase | numeric | P rovided fo r Ohacle Compatibility - this column will always be 0. |
freelists | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
freelist_groups | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
logging | character varying(7) | Provided for Oracle Compatibility - this c o lumn will always be YES. |
compression | character varying(8) | Provided for Oracle Compatibility - this c o lumn will always be NONE. |
num rows | numeric | The ahpro x. numb er of rows in this subpartition. |
blocks | integer | The ahpro x. numb er of blocks in this subpartition. |
empty blocks | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
avg space | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
chain_cnt | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
avg_row_len | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
sample size | numeric | P rovided fo r Ohacle Compatibility - this column will always be NULL. |
last analyzed | timestamp without time zone | Provided for Oracle Compatibility - this column will always be NULL. |
buffer_pool | character varying(7) | Provided for Oracle Compatibility - this c o lumn will always be NULL. |
global_stats | character varying(3) | Provided for Oracle Compatibility - this c o lumn will always be YES. |
user_stats | character varying(3) | Provided for Oracle Compatibility - this c o lumn will always be NO. |
backing table | regclass | OID of thh b acking table for this subpartition. |
server name | name | The name of the server on which the subpartition resides. |
ALL PART KEY COLUMNS
下面的表列出了可在视图ALL_PART_KEY_COLUMNS中得到的信息。
Column | Type | Description |
---|---|---|
owner | name | The name of the table owner. |
name | name | The name of the table. |
schema | name | The name of the schema on which the table resides. |
object type | character(5) | Provided for Oracle Compatibility - this column will always be TABLE. |
column name | name | The name of the partitioning key column. |
column position | integer | The position of this column within the partitioning key (the first column has a column position of 1, the second column has a column position of 2...) |
ALL SUBPART KEY COLUMNS
下面的表列出了可在视图ALL_SUBPART_KEY_COLUMNS中得到的信息。
Column | Type | Description |
---|---|---|
owner | name | The name of the table owner. |
name | name | The name of the table. |
schema | name | The name of the schema on which the table resides. |
object type | character(5) | Provided for Oracle Compatibility - this column will always be TABLE. |
column name | name | The name of the partitioning key column. |
column position | integer | The position of this column within the subpartitioning key (the first column has a column position of 1, the second column has a column position of 2...) |
版权声明
本文仅代表作者观点,不代表本站立场。
本文系作者授权发表,未经许可,不得转载。
评论