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_TABLESdescribes object-level information for partitioned external tables in the database -
USER_XTERNAL_PART_TABLESdescribes object-level information for partitioned external tables owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the partitioned external table |
|
|
|
|
Name of the partitioned external table |
|
|
|
Owner of the implementation type for the external table access driver |
|
|
|
|
Name of the implementation type for the external table access driver |
|
|
|
|
Owner of the default directory for the external table |
|
|
|
|
Name of the default directory for the external table |
|
|
|
|
Reject limit for the external table, or |
|
|
|
|
Type of access parameters for the external table ( |
|
|
|
|
Access parameters for the external table |
|
|
|
|
Property of the external table ( |
|
|
|
|
Indicates whether the In-Memory Column Store (IM column store) is by default enabled ( |
|
|
|
|
Indicates the default compression level for the IM column store:
|
Footnote 1 This 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.
See Also:
-
“DBA_XTERNAL_PART_TABLES”
-
“USER_XTERNAL_PART_TABLES”
