Oracle/MySQL 관련 게시판

Oracle/MySQL 관련 게시판

2014/03/19(23:40) from 180.65.248.176
작성자 : 주인장	조회수 : 3470 , 줄수 : 17

Re: [Oracle] ORA-12899: value too large for column

@ Unix Oracle -> PC Oracle로 Table export / import 할때 나는 에러
오류 보고:
SQL 오류: ORA-12899: value too large for column "JKKANG"."COMM800"."USER" (actual: 32, maximum: 30)
12899. 00000 - "value too large for column %s (actual: %s, maximum: %s)"
*Cause:    An attempt was made to insert or update a column with a value
          which is too wide for the width of the destination column.
          The name of the column is given, along with the actual width
          of the value, and the maximum allowed width of the column.
          Note that widths are reported in characters if character length
          semantics are in effect for the column, otherwise widths are
          reported in bytes.
*Action:   Examine the SQL statement for correctness. Check source
          and destination column data types.
          Either make the destination column wider, or use a subset
          of the source column (i.e. use substring).

@ 해결책