How to resize LOB segments online
We have a BLOB column in a table, which is updated very frequently. Unfortunately we created the lob with the option pctversion=100, because of performance reasons.
Now our table wasts a lot of space for storing all versions of this lob.
Now my question: Is it possible to resize log segment space ONILNE!
As fas as I know the command "alter table .. move lob(..) ..." does not work online.
Regards
Andreas