Search code examples
sqldatabaseoracle-databaseclob

Oracle SQL Database creating a clob with size greater than 4000

I'm trying to alter table and add a new column as a clob, but I'm only allowed to set the size to 4,000. The syntax I'm using is: 

ALTER TABLE table_name
add column_name CLOB(100000)

The error I'm getting is:

ORA-01735: invalid ALTER TABLE option

If I put:

ALTER TABLE table_name
add column_name CLOB

This allows me to create a column of default size 4,000.

Solution

  • It is telling you invalid ALTER TABLE option because it is an invalid option - you can't specify the size of the clob.