Q & A

Schema Error!

Date2002.05.30 / Hit : 19572
안녕하세요!!! ORANGE ver : 2.0.2.5.24(DBA) ORACLE7 server : 7.3.4.4.0 Plan Tool 에서 Schema를 실행시켰을때 Error가 발생하고 있습니다. -------- 아 래 ------------- GCSMSTGD -------- Rows=1,204 Blocks=75 Empty Blocks=437 Avg Space=105 Chain Count=54 Avg Row Length=110 Avg Space Freelist Blocks=N/A Freelist Blocks=N/A Sample Size=N/A Last Analyze=N/A Partitioned=NO Column Name Nullable Column Type Distinct Buckets -------------------------------- -------- ------------- ---------- ---------- STGDCODE Not Null VARCHAR2(8) 1,181 1 STGDSTDT Not Null VARCHAR2(8) 23 1 STGDEDDT Not Null VARCHAR2(8) 17 1 STGDNAME Not Null VARCHAR2(100) 979 1 STGDSERL VARCHAR2(10) 599 1 STGDGDGB Not Null VARCHAR2(1) 7 1 STGDCDGB Not Null VARCHAR2(1) 3 1 STGDSTRD VARCHAR2(30) 198 1 STGDUNIT Not Null VARCHAR2(3) 10 1 STGDWNUP NUMBER(14,2) 73 1 STGDDLUP NUMBER(14,2) 1 1 STGDWSUP NUMBER(14,2) 29 1 STGDWSYN VARCHAR2(1) 3 1 STGDWSSN VARCHAR2(3) 80 1 STGDSUPP VARCHAR2(5) 4 1 STGDMFCM VARCHAR2(5) 2 1 STGDJSQT NUMBER(10) 1 1 STGDCSQT NUMBER(10) 1 1 STGDVLDT Not Null NUMBER(4) 4 1 STGDSTYN Not Null VARCHAR2(1) 3 1 STGDALYN Not Null VARCHAR2(1) 2 1 STGDSPDD VARCHAR2(8) 1 1 STGDCOMT VARCHAR2(100) 4 1 STGDCOLR VARCHAR2(30) 31 1 STGDMTRL VARCHAR2(30) 35 1 STGDSTQT NUMBER(10) 219 1 STGDWKPN Not Null VARCHAR2(6) 3 1 STGDWKDT DATE 359 1 INDEX ----------------------------------------------------------------------------- Error!!! ORA-00904 : invalid column name
  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

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