Oracle 视图 ALL_STREAMS_NEWLY_SUPPORTED 官方解释,作用,如何使用详细说明
本站中文解释
( DBA View)
Oracle视图 ALL_STREAMS_NEWLY_SUPPORTED 是一个 DBA 视图, 用来查询从一个时间点开始创建的 Streams 配置对象。它提供了对数据库中最新 Streams 设置的概况信息,这样您就可以更快地执行诊断和疑难解答。
ALL_STREAMS_NEWLY_SUPPORTED 视图提供以下字段:
OWNER: 对象拥有者
OBJECT_NAME: 对象名称
OBJECT_TYPE: 对象类型
CREATED_TIMESTAMP: 对象的创建时间
使用方法:
1. 构造一条查询语句,查询在某个时间点之后创建的对象:
SELECT owner,object_name,object_type,created_timestamp
FROM all_streams_newly_supported
WHERE created_timestamp > ‘yyyy-mm-dd HH24:MI:SS’;
2. 构造一条不带条件的查询语句,查询所有 Streams 对象:
SELECT owner,object_name,object_type,created_timestamp
FROM all_streams_newly_supported;
官方英文解释
ALL_STREAMS_NEWLY_SUPPORTED
displays information about the tables accessible to the current user that are newly supported by capture processes.
Related View
DBA_STREAMS_NEWLY_SUPPORTED
displays information about all tables in the database that are newly supported by capture processes.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Reason why the table was not supported in a previous release:
|
|
|
|
Minimum database compatibility for capture processes to support the database object |
See Also:
“DBA_STREAMS_NEWLY_SUPPORTED”