Is there a way to update the default initial storage size of the LOB column in Oracle database
On Oracle 12.1.0.2:
We've noticed that on a database which has partitioning already enabled and new LOB columns added afterwards, initial storage for a LOB column is 8M (8388608).
Meanwhile, on a system where the LOB columns exist already, and the partitioning would be enabled later, initial storage is 0.1M (106496).
Owing to the way our product makes use of the DB, both situations can occur on customer premises.
As the number of partitions and/or columns can be quite large, the difference results in potentially very big difference between the two scenarios.
As a result, *customer cannot upgrade to a newer version of our product* due to storage limitations (LOB PARTITION of more than 74 GB, and the upgrade failing due to disk space limitation).