Is there a limitation on the number of BLOB or LOB columns in an Oracle 8.1.7 table?
Thanks.
Printable View
Is there a limitation on the number of BLOB or LOB columns in an Oracle 8.1.7 table?
Thanks.
There is no limitation on the number of LOB, BLOB columns per table except the normal column limits for a table. the there is a limitation on size (4Gb I seem to recall)
Hope that makes sense :)
Regards
yes, 4GB is the limit for blob and clob.
BTW -- do you guys know any tip when using blobs and clobs? I mean, how do make sure the system's overall performance when using the b/clobs? Since I am going to work on a project using b/clobs extensively, I'd like to know what should I do during the design time to make sure they won't drag the overall performance.
TIA!
Hey Elaine;
As luck would have it I am studying for the 8i upgrade exam and there is an entire chapter on LOB's. Do you have this ILT?
You will find guidlines for caching or nocacheing options, using temporary LOB's, internal LOB's and the like.
I just started reading this and really have no experience with LOB's so there is only so much I can do to help. If you can get your hands on chapter 6 of the ILT I'm sure it will help you out.
MH
I am only on my 2nd OCP exam (AA), so I haven't seen much of LOBs yet. Do LOBs appear in Performance Tuning?
Thanks for the info!