Error: ORA-12899: value too large for column
Symptoms:
When user tries to scan metadata from a Data-Model or any other file, error is thrown as an exception with Oracle database as a backend
Resolution:
DECLARE
COLUMNCHECKERFLAG INT;
BEGIN
SELECT COUNT(*) INTO COLUMNCHECKERFLAG FROM ALL_TAB_COLUMNS WHERE OWNER = sys_context('userenv', 'current_schema') AND TABLE_NAME = UPPER('SYSTEM_TABLE_COLUMNS_METADATA') AND COLUMN_NAME=UPPER('FK_TABLE_NAME') AND DATA_LENGTH=UPPER('50');
IF COLUMNCHECKERFLAG = 1 THEN
EXECUTE IMMEDIATE 'ALTER TABLE SYSTEM_TABLE_COLUMNS_METADATA MODIFY (FK_TABLE_NAME VARCHAR2(250))';
END IF;
END;
/
ALTER TABLE SYSTEM_TABLE_COLUMNS_METADATA MODIFY (FK_TABLE_NAME VARCHAR2(250))
commit;
User then will not face this issue when tries to scan the metadata from the data-model or any repositories.
If there are any issues or questions feel free to open a ticket with support: https://support.erwin.com/hc/en-us/requests/new
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center