SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Things to consider while designing CLOB Columns

Rajan SwJun 16 2022

Hi Experts,

I am designing a table which will be used for storing forms mostly JSON data. So a created a column in the table as CLOB data type.
This column would be mainly used for data retrieval, and not much updates, So what are the best practices to design this column, like should we define a separate table space which will have LOB segment for storing the column data.

This column column would be used very frequently.
Please share any thoughts or approaches.

Thanks in advance !!

Currently we are using oracle
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Added on Jun 16 2022

3 comments

1,173 views