i'm new to dba.i have a table on tablespace ts1.i took that tablespace ts1 offline, and when i give a select query on the table, it throws an error like 'cannot access file 2'.
i cached that table giving 'alter table cache;' then tried to give the select query, still giving the same error.

if, the table is cached in memory, oracle can get the table from there, why it is searching in the disk?

kindly reply,
saravann kumar