Q & A

Re: RE: 오렌지 7.0 버전 7.0.5 빌드 374 설치 후 플랜이 안됩니다.

Date2026.06.12 / Hit : 38
-- DDL Script was generated by Orange for TIBERO
-- using session 'INSA@조선 운영DB(Tibero)_10.10.42.100' on '2026/06/12 07:56:18.000000'.

CREATE GLOBAL TEMPORARY TABLE SYS.PLAN_TABLE
(
    STATEMENT_ID        VARCHAR(128),
    SQL_ID              VARCHAR(13),
    CHILD_NUMBER        NUMBER,
    TIMESTAMP           DATE,
    OPERATION           VARCHAR(128),
    OBJECT_OWNER        VARCHAR(128),
    OBJECT_NAME         VARCHAR(128),
    OBJECT_TYPE         VARCHAR(30),
    SEARCH_COLUMNS      NUMBER,
    ID                  NUMBER,
    PARENT_ID           NUMBER,
    DEPTH               NUMBER,
    POSITION            NUMBER,
    COST                NUMBER,
    CARDINALITY         NUMBER,
    PARTITION_START     VARCHAR(255),
    PARTITION_END       VARCHAR(255),
    OTHERS              VARCHAR(4000),
    ACCESS_PREDICATES   VARCHAR(4000),
    FILTER_PREDICATES   VARCHAR(4000)
)
ON COMMIT PRESERVE ROWS;

GRANT DELETE ON SYS.PLAN_TABLE TO PUBLIC;
GRANT INSERT ON SYS.PLAN_TABLE TO PUBLIC;
GRANT SELECT ON SYS.PLAN_TABLE TO PUBLIC;
GRANT UPDATE ON SYS.PLAN_TABLE TO PUBLIC;

COMMENT ON COLUMN SYS.PLAN_TABLE.STATEMENT_ID IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.SQL_ID IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.CHILD_NUMBER IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.TIMESTAMP IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.OPERATION IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.OBJECT_OWNER IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.OBJECT_NAME IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.OBJECT_TYPE IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.SEARCH_COLUMNS IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.ID IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.PARENT_ID IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.DEPTH IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.POSITION IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.COST IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.CARDINALITY IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.PARTITION_START IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.PARTITION_END IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.OTHERS IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.ACCESS_PREDICATES IS '';
COMMENT ON COLUMN SYS.PLAN_TABLE.FILTER_PREDICATES IS '';

CREATE PUBLIC SYNONYM PLAN_TABLE
FOR SYS.PLAN_TABLE;


스크립트입니다.

조회되는것 확인했고 GRANT 도 PUBLIC이며 조회여부와 상관없이 에러메세지는 ORANGE_PLAN_TABLE 을 찾으라고 합니다.

저 말고 업데이트한 다른 분도 동일한 증상입니다.
  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

  • 라이선스 문의
    02-6931-1728