sql - ORA-00945 : specified clustered column does not exist

Question

这是包含集群的代码，表永​​远不会被创建并且 oracle 文档是屁股

create cluster c123 (a integer)
size 512;
/

drop table t123;
/

create table t123
cluster c123 (b)
as SELECT t1.col1 FROM T1, T2, T3
WHERE T1.col1=T3.col11 AND
T2.col1=T3.col12 AND T1.col2=1;
/

它需要创建表格，而不是我不断获取

...
Error report -
ORA-00945: specified clustered column does not exist
00945. 00000 -  "specified clustered column does not exist"
*Cause:    
*Action:

Answer 1

您可以添加别名:

create table t123
cluster c123 (b)
as 
SELECT t1.col1 AS b
FROM T1
JOIN T2 ON T1.col1=T2.col11
JOIN T3 ON T2.col1=T3.col12
WHERE T1.col2=1;