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 ?

- Rajeev