Forum Stats

  • 3,839,355 Users
  • 2,262,485 Discussions
  • 7,900,946 Comments

Discussions

Advanced compression- LOB Table

rangapavan
rangapavan Member Posts: 331
edited Apr 30, 2013 8:54AM in Advanced Compression
hi all,
is there any way to compress LOB table using advanced compression?

Thanks in Advance!

Answers

  • Matthias K. F. Schulz
    Matthias K. F. Schulz Member Posts: 109 Blue Ribbon
    Hi!

    The compression method used by Advanced Compression won't compress LOB's in most cases anyway.

    You may try the package utl_compress instead:

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12980645053487

    http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/u_compr.htm#ARPLS70827

    Best regards,
    Matt
This discussion has been closed.