Oracle教程 2023-02-23

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

本站中文解释

驗證外部表是否有效

Oracle视图ALL_EXTERNAL_PART_TABLES查询显示具有外部表分区的当前用户下具有分区的所有外部表。此外，它还提供有关它们所使用的文件位置和格式的详细信息。

使用ALL_EXTERNAL_PART_TABLES视图可以驗證指定的外部表是否有效，并且可以在有问题的情况下对外部表进行调试。

要从ALL_EXTERNAL_PART_TABLES视图中检索信息，请使用以下示例查询：

SELECT table_name, partition_name, external_file_name, log_file_name, format_type
FROM all_external_part_tables
WHERE owner = ‘USERNAME’ AND table_name = ‘tablename’;

官方英文解释

ALL_XTERNAL_PART_TABLES describes object-level information for partitioned external tables accessible to the current user.

Related Views

DBA_XTERNAL_PART_TABLES describes object-level information for partitioned external tables in the database
USER_XTERNAL_PART_TABLES describes object-level information for partitioned external tables owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the partitioned external table
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the partitioned external table
`TYPE_OWNER`	`CHAR(3)`		Owner of the implementation type for the external table access driver
`TYPE_NAME`	`VARCHAR2(128)`		Name of the implementation type for the external table access driver
`DEFAULT_DIRECTORY_OWNER`	`CHAR(3)`		Owner of the default directory for the external table
`DEFAULT_DIRECTORY_NAME`	`VARCHAR2(128)`		Name of the default directory for the external table
`REJECT_LIMIT`	`VARCHAR2(40)`		Reject limit for the external table, or `UNLIMITED`
`ACCESS_TYPE`	`VARCHAR2(7)`		Type of access parameters for the external table (`BLOB`, `CLOB`)
`ACCESS_PARAMETERS`	`CLOB`		Access parameters for the external table
`PROPERTY`	`VARCHAR2(10)`		Property of the external table (`REFERENCED`, `ALL`)
`INMEMORY`^Foot 1	`VARCHAR2(8)`		Indicates whether the In-Memory Column Store (IM column store) is by default enabled (`ENABLED`), disabled (`DISABLED`), or not specified (`NONE`) for partitions in the external table
`INMEMORY_COMPRESSION`^Foot 1	`VARCHAR2(17)`		Indicates the default compression level for the IM column store: `NO MEMCOMPRESS` `FOR DML` `FOR QUERY [ LOW \| HIGH ]` `FOR CAPACITY [ LOW \| HIGH ]` `NULL`

^Footnote 1This column is available starting with Oracle Database 21c. It appears in the USER_XTERNAL_PART_TABLES view and is omitted from the ALL_XTERNAL_PART_TABLES and DBA_XTERNAL_PART_TABLES views.

本站中文解释

官方英文解释

相关推荐