Oracle 视图 DBA_SR_OBJ 官方解释，作用，如何使用详细说明
本站中文解释
ECTS
Oracle视图DBA_SR_OBJECTS用于查询当前数据库中已被灵活事务处理（Flexible Transaction Processing）服务管理的对象列表。
它提供两个重要信息：
1. 受FTP管理的对象类型
2. 这些对象所属的用户
可以使用DBA_SR_OBJECTS视图来查询哪些用户在哪些对象上启用了FTP服务。具体用法如下：
SELECT *
FROM DBA_SR_OBJECTS
WHERE OBJECT_TYPE = ”
AND OWNER = ;
官方英文解释
DBA_SR_OBJ provides information on the objects registered for synchronous refresh for current groups.
Related View
USER_SR_OBJ provides information on the objects registered for synchronous refresh for current groups for the current user. Its columns are the same as those in DBA_SR_OBJ.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the synchronous refresh object |
|
|
|
|
Name of the synchronous refresh object |
|
|
|
Type of synchronous refresh object:
|
|
|
|
|
|
Group ID of the synchronous refresh group to which this object belongs |
|
|
|
Name of the staging log for tables. This column has a value of NULL for materialized views. |
See Also:
“USER_SR_OBJ”
