Skip to Main Content

Oracle Database Discussions

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!

LONG vs. CLOB

537177Sep 27 2007 — edited Sep 27 2007
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2007
Added on Sep 27 2007
6 comments
2,289 views