Oracle教程 2023-02-24

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

本站中文解释

查询说明

　　Oracle视图ALL_FILE_GROUPS是Oracle数据库所提供的内建视图，用于按照目标实例库中指定的表空间名称检索文件组信息。

　　ALL_FILE_GROUPS视图中有多列字段，用户可以通过查询ALL_FILE_GROUPS视图，来获取指定用户所有表空间中所拥有的文件组信息，包括每个文件组的名称、文件组下所有文件的路劲、自动缩减等信息。

使用示例：

查询指定表空间的所有文件组信息：
“` SQL
SELECT * FROM ALL_FILE_GROUPS WHERE TABLESPACE_NAME = ‘TEST_TABLESPACE’;
“`
查询指定用户的所有文件组信息：
“` SQL
SELECT * FROM ALL_FILE_GROUPS WHERE OWNER = ‘USR1’;
“`

官方英文解释

ALL_FILE_GROUPS shows top-level metadata about the file groups accessible to the current user.

Related Views

DBA_FILE_GROUPS shows top-level metadata about all file groups in the database.
USER_FILE_GROUPS shows top-level metadata about file groups owned by the current user. This view does not display the FILE_GROUP_OWNER column.

Column	Datatype	NULL	Description
`FILE_GROUP_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the file group
`FILE_GROUP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the file group
`KEEP_FILES`	`VARCHAR2(1)`	`NOT NULL`	A value of Y or N to indicate whether or not files should be deleted when a version is purged
`MIN_VERSIONS`	`NUMBER`	`NOT NULL`	Autopurge should not drop a version if this condition will become violated
`MAX_VERSIONS`	`NUMBER`	`NOT NULL`	Autopurge will drop the oldest version when this condition is violated
`RETENTION_DAYS`	`NUMBER`	`NOT NULL`	Autopurge will drop versions older than this if doing so does not violate `MIN_VERSIONS`
`CREATED`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	Time at which the file group was created
`COMMENTS`	`VARCHAR2(4000)`		Comments about the file group
`DEFAULT_DIRECTORY`	`VARCHAR2(128)`		Name of the default directory object

本站中文解释

官方英文解释

相关推荐