Search code examples
databaseoracle-databaseoracle11gddlalter-table

How to remove a table from cache in Oracle?

I tried to add a table to cache in Oracle 

alter table Test_Table cache;

So now how can I remove it from cache?

Solution

  • You can do:

    alter table Test_Table NOCACHE;

    But be aware that using the cache doesn't actually pin the table in cache. It just tells oracle to handle the blocks differently once they get there. Tom Kyte has a good explanantion on this.