Oracle 视图 ALL_APPLY_INSTANTIATED_SCHEMAS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_APPLY_INSTANTIATED_SCHEMAS视图描述当前用户在数据库实例中所申请的注册过的模式。该视图中只包括当前用户的操作，而不包括其它用户的操作。
ALL_APPLY_INSTANTIATED_SCHEMAS视图的主要用途是用来查询和管理当前用户所注册过的模式。可以使用该视图来查询当前用户的模式的状态，查看模式的注册记录，查询模式的相关信息，并进行管理和控制。
使用ALL_APPLY_INSTANTIATED_SCHEMAS视图的语法形式如下：
SELECT * FROM ALL_APPLY_INSTANTIATED_SCHEMAS;
此外，还可以通过以下语句指定条件查询模式信息：
SELECT * FROM ALL_APPLY_INSTANTIATED_SCHEMAS WHERE = ;
官方英文解释
ALL_APPLY_INSTANTIATED_SCHEMAS displays information about schemas accessible to the current user for which an instantiation SCN has been set.
Related View
DBA_APPLY_INSTANTIATED_SCHEMAS displays information about schemas for which an instantiation SCN has been set.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the database where the schema originated |
|
|
|
Name of the schema at the source database |
|
|
|
|
Instantiation SCN for the schema. Only changes committed after this SCN are applied by an apply process. |
|
|
|
|
Database link to which changes are applied. If null, then changes are applied to the local database. |
|
|
|
|
The global name of the source root database |
See Also:
“DBA_APPLY_INSTANTIATED_SCHEMAS”
