How can I allow a regular user to create tables with Varchar2(32767) columns?
When I issue this command under a regular user:
CREATE TABLE TestVarchar32767 (A VARCHAR2(32767))
It throws this error:
Error starting at line : 1 in command -
CREATE TABLE HttpingTestVarchar32767 (A VARCHAR2(32767))
Error report -
SQL Error: ORA-00910: specified length too long for its datatype
00910. 00000 - "specified length too long for its datatype"
*Cause: for datatypes CHAR and RAW, the length specified was > 2000;
otherwise, the length specified was > 4000.
*Action: use a shorter length or switch to a datatype permitting a
longer length such as a VARCHAR2, LONG CHAR, or LONG RAW
But if I issue it under SYS as SYSDBA, then it works.