This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,438 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

advanced compression for OLTP

798372
798372 Member Posts: 1
edited Oct 7, 2010 7:33PM in Advanced Compression
If a new insert takes place on a compressed table will it go to the end of the table or to a new block.

Edited by: ahmed on Sep 21, 2010 12:20 PM
Tagged:

Answers

  • damorgan
    damorgan Oracle ACE Director Planet EarthMember Posts: 14,464 Bronze Crown
    edited Oct 7, 2010 7:33PM
    If you use DIRECT LOAD then it will, by definition, be placed above the high-water mark.

    Probably not something you want to do one row at a time.
    damorgan
This discussion has been closed.