Database Administration (MOSC)

MOSC Banner

acceptable ORA-12899

edited May 7, 2012 8:21PM in Database Administration (MOSC) 12 commentsAnswered
i executed an insert statment while an error rose up: ORA-12899 value too large (actul:69,max:64).

Then i found this value,and tested it.

create table TEST_LENGTH( A VARCHAR2(64));

select length('getNewB? ??÷???¤ M????°?? ?×?P·5??f?lient-Agent: CMREAD_Javami') from dual----return:64

 INSERT INTO CX_FUJIE.TEST_LENGTH
    select 'getNewB? ??÷???¤ M????°?? ?×?P·5??f?lient-Agent: CMREAD_Javami'
      from dual;-----error rose up: ORA-12899 value too large (actul:69,max:64).

could someone give me an aid?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center