LONG vs. CLOB
537177Sep 27 2007 — edited Sep 27 2007Hi,
I am running Oracle 9.2 and need to make some changes to PL/SQL code,
which has a lot of long variables where VIEWS definitions are saved.
Now I remember there was a advice to go away from LONG and try to use CLOB as datatype.
I was able to find some restriction of LONG like:
Only one LONG column is allowed per table.
Maximum size: 2 GB - 1
CLOB:
The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Footref 1).
Maximum size: (4 GB - 1)
Still not sure if there any other considirations?
Lets say I am fine with 2 GB and I do not need motre than 1 column.
Why should I move to CLOB?
Thanks