文档解释
ORA-25965: fact table must be included in the from clause
Cause: An attempt to create a join index was made, which failed because the from clause does not contain the fact table.
Action: Ensure that the from clause contains the fact table.
ORA-25965 错误代表事实表必须包含在 FROM 子句中。
官方解释
ORA-25965 是 “fact table must be included in the from clause” 错误,它指出 MySQL 也称为“事实表”的 FROM 子句是必需的。
常见案例
在 SQL 语句中,将不包含事实表的 FROM 子句运行时,可能会收到此错误:
ORA-25965: fact table must be included in the from clause
一般处理方法及步骤
1.检查“From”子句中是否包含事实表;
2.如果不包含,则必须将事实表添加到“From”子句中。