ORA-00976: 此处不允许指定的伪列或运算符
求指导,optimizer_features_enable 值已经修改尝试过了,没有效果
sql代码:
SELECT /*+ FIRST_ROWS(10) PARALLEL (XDS_DOCUMENT, 4) INDEX(XDS_DOCUMENT PK_XDS_ENTITY) */
XDS_DOCUMENT.REVISION,
XDS_DOCUMENT.DOCUMENT_ID,
XDS_DOCUMENT.NAME,
XDS_DOCUMENT.QUALIFIED_NAME,
XDS_DOCUMENT.DESCRIPTION,
XDS_DOCUMENT.CREATED_BY,
XDS_DOCUMENT.LASTMODIFIED_BY,
XDS_DOCUMENT.LASTMODIFIED_DATE,
XDS_DOCUMENT.CREATED_DATE,
XDS_DOCUMENT.ANNOTATION,
XDS_DOCUMENT.TYPE_ID,
XDS_DOCUMENT.TYPE_REVISION,
XDS_DOCUMENT.PARENT_ID,
XDS_DOCUMENT.OPTIMISTIC_LOCK,
XDS_DOCUMENT.ACCESSCONTROLPOLICY_ID,
XDS_DOCUMENT.INHERIT_PARENT_ACP,
XDS_DOCUMENT.STACK_LEVEL,
XDS_DOCUMENT.CONTENT
FROM XDS_DOCUMENT XDS_DOCUMENT
INNER JOIN (SELECT D2.DOCUMENT_ID, MAX(STACK_LEVEL) AS BLEVEL
FROM XDS_DOCUMENT D2
WHERE D2.REVISION IN
(SELECT REGISTERED_REVISION
FROM XDS_BRANCH
START WITH BRANCH_ID = 'E41F131E-A5FA-11E0-FF0B-4C0D519DB0F2'
CONNECT BY PRIOR PARENT_ID = BRANCH_ID)
AND D2.DOCUMENT_ID = 'E41F131E-A5FA-11E0-F8C5-E7D54B52D32B'
AND D2.TYPE_ID = 'ID_TYPE_XMLDOCUMENT'
GROUP BY D2.DOCUMENT_ID) SUB_RESULT
ON XDS_DOCUMENT.REVISION IN
(SELECT REGISTERED_REVISION
FROM XDS_BRANCH
START WITH BRANCH_ID = 'E41F131E-A5FA-11E0-FF0B-4C0D519DB0F2'
CONNECT BY PRIOR PARENT_ID = BRANCH_ID)
AND XDS_DOCUMENT.STACK_LEVEL = SUB_RESULT.BLEVEL
AND XDS_DOCUMENT.DOCUMENT_ID = SUB_RESULT.DOCUMENT_ID