[Question]: 视图创建问题

[wyyzy]

我在SDS_CITICS（schema）下，创建了SDS_BRANCHES表，然后在ECAS_CITICS（schema）下创建如下视图：
CREATE OR REPLACE VIEW ECAS_BASBANK AS
SELECT A.BRANCHES_CODE BANKID, A.BRANCHES_NAME NAME,
NVL(B.BRANCHES_CODE,'0') HEAD,A.BRANCHESLOCALNAME CHSNAME,A.BRANCHES_NAME ENGNAME,
CASE A.BRANCHESTYPE WHEN 'I' THEN 0 WHEN 'V' THEN 1 WHEN 'D' THEN 2 WHEN 'O' THEN 3 END TYPE,
CASE A.LOCKED WHEN 'Y' THEN 1 WHEN 'N' THEN 0 END ENABLED,A.BRANCHESLEVEL + 1 LVL,
'' RBSBANKID,'' SBSBANKID,'' BANCSBANKID,'' EFFECTBANKID
FROM SDS_CITICS.SDS_BRANCHES A
LEFT JOIN SDS_CITICS.SDS_BRANCHES B
ON A.BRANCHES_ID_PARENT = B.BRANCHES_ID;
报错：SQL 错误 [942] [42S02]: (conn=3221507849) ORA-00942: table or view does not exist

意图是在ECAS_CITICS中通过视图读取SDS_CITICS中的SDS_BRANCHES表数据。

查看官网文档未找到相关说明，想咨询下，是否是权限问题导致的或者oceanbase本身就不支持建跨schema查询的视图？

[hnwyllmm]

如果要跨库访问数据，可以使用dblink，参考一下文档：https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000641885