Quote:
Originally posted by ksarav
but my doubt is, i took a tablespace offline which contains a table, i cached that table(using 'alter table _name_ cache;)
usually,when you give a select query, oracle searches for the table in buffer, and if it finds the table in buffer, it gives you the result..,
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.