I want to the varchar2 max size in oracle126.96.36.199.0 for solaris.
I have a table in coracle188.8.131.52.0 for solaris, there is a column of varchar2. firstly, I set its size 4000, then I want to extend to 8000, but there is a oracle error ora-00910 which said that specified length too long for the datatype. I looked up the docs, and it said the max size can be up to 32767. now I confused of it and don't know what i can do to extend the column size. You advice will be appreciate.
A VARCHAR2 *variable* can be 32767, but a column can only be 4000. But be careful, because Oracle was sloppy when they changed from 2000 to 4000. DBMS_SQL.Varchar2_Table is still defined at 2000, for example, so it won't work for larger columns. So much for consistency, eh?