You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
我在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
我在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查询的视图?
The text was updated successfully, but these errors were encountered: