One of our applications will heavily make use of LOBs in the tables underneath. One of my users asked me if we should keep the LOB-heavy-tables in a separate tablespace.
I don't know what the advantages will be to keep them in a separate tablespace.
Currently they are in a tablespace that has other BIG non-LOB-tables as well and all the tables have been created with the uniform Extent_sizes.
Could anyone point out a few advantages of keeping LOB-tables in a separate tablespace ?
Click Here to Expand Forum to Full Width