DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: BLOBs and LOBs

  1. 01-22-2002, 10:49 AM #1
    CBW
    CBW is offline Junior Member
    Join Date
    Nov 2000
    Posts
    74
    Is there a limitation on the number of BLOB or LOB columns in an Oracle 8.1.7 table?

    Thanks.
    Reply With Quote Reply With Quote
  2. 01-22-2002, 11:18 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 01-22-2002, 11:31 AM #3
    elaine3839
    elaine3839 is offline Senior Member
    Join Date
    May 2001
    Posts
    285

    how to make blob & clob more efficient?

    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!

    Reply With Quote Reply With Quote
  4. 01-22-2002, 11:38 AM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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 remember when this place was cool.
    Reply With Quote Reply With Quote
  5. 01-22-2002, 12:14 PM #5
    elaine3839
    elaine3839 is offline Senior Member
    Join Date
    May 2001
    Posts
    285

    Thanks MH, but...

    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width