[Tibero] TBR-5072: Failure converting NUMBER to or from a native type

 

TBR-5072: 에러 해결하기

 

Tool : tbAdmin 

툴에서 테이블 삭제시 발생

 

 

해결방법

 

1) SYS계정 로그인

2) SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OWNER = '[OWNER_NAME]' AND OBJECT_NAME = '[TABLE_NAME]' ;

3) SELECT OBJ_ID FROM _DD_TBL WHERE OBJ_ID = [2번에서 알아낸 OBJECT_ID] ;

4) UPDATE _DD_TBL SET ROW_CNT = 0 WHERE OBJ_ID = [3번에서 알아낸 OBJ_ID] ;

5) Commit;