ORA-18170: FTST0011 FTWindow and FTDistance restriction

文档解释

ORA-18170: FTST0011 FTWindow and FTDistance restriction

Cause: An implementation may restrict the use of FTWindow and FTDistance to an FTOr that is either a single FTWords or a combination of FTWords involving only the operators && and ||. If it a static error if, during the static analysis phase, an expression is found that violates this restriction and the implementation enforces this restriction.

Action: Follow FTWindow and FTDistance restriction.

官方解释

常见案例

一般处理方法及步骤

1.首先，检测客户端是否正确地访问FTService。检查它是否正确地设置了FTWindow和FTDistance参数。

2.如果客户端正确地设置了FTWindow和FTDistance参数，应该在服务端检查FTService配置，查看是否存在任何FTWindow和FTDistance受到限制的情况。

3.如果发现FTService配置存在问题，可以尝试调整FTWindow和FTDistance限制，使它们允许客户端访问更多的资源。

4.如果仍存在问题，可以尝试重新启动FTService，看能否纠正任何错误配置。