Oracle 视图 ALL_FILE_GROUP_EXPORT_INFO 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图 ALL_FILE_GROUP_EXPORT_INFO 查询仅在数据库版本12.2及其之后包含跨文件组和跨表空间数据定义语言(DDL)导出工具(expdp)使用的更多表空间和文件组信息。此视图在非此版本的数据库中不可用。
ALL_FILE_GROUP_EXPORT_INFO 视图包含以下列:
– FILE_ID:文件ID
– FILEGROUP_ID:文件组ID
– LOGICAL_FILENAME:逻辑文件名
– TABLESPACE_NAME:表空间名称
– DIRECTORY_NAME:目录名称
– FILE_NAME:文件名称
– BLOCK_SIZE:块大小
使用方法:
1. 首先执行数据库版本 12.2 及以上的时候就可以使用 ALL_FILE_GROUP_EXPORT_INFO 这个视图了;
2. 然后,根据我们需要查询的跨文件组和跨表空间数据信息,可以使用SELECT语句从ALL_FILE_GROUP_EXPORT_INFO 视图中查询出想要的信息;
3. 然后,我们可以根据这些信息来创建我们想要的表空间或文件组等等。
官方英文解释
ALL_FILE_GROUP_EXPORT_INFO
shows export-related information for each version accessible to the current user. There will only be information in this view for versions that have a valid Data Pump dump file.
Related Views
-
DBA_FILE_GROUP_EXPORT_INFO
shows export-related information for each version in the database that has a valid Data Pump dump file. -
USER_FILE_GROUP_EXPORT_INFO
shows export-related information for all file groups owned by the current user. This view does not display theFILE_GROUP_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the file group |
|
|
|
Name of the file group |
|
|
|
User-specified name for the version |
|
|
|
Internal version number |
|
|
|
Version of exported objects |
|
|
|
Platform on which the export was performed |
|
|
|
Time at which the export job was performed |
|
|
SCN of the export job |
|
|
|
Global name of the exporting database |
See Also:
-
“DBA_FILE_GROUP_EXPORT_INFO”
-
“USER_FILE_GROUP_EXPORT_INFO”