Originally posted by jmodic
When you take tablespace offline Oracle flushes all the buffers belonging to that tablespace out of the buffer cache - so you realy have nothing from that tablespace cached any more once you take it offline.
But i don't think that would be true for tables cached in the keep pool... they are still in the keep cache even after the tablespace is taken offline...