How to check cached tables changing CACHE to NOCACHE

SELECT TABLE_NAME,CACHE FROM DBA_TABLES
WHERE LTRIM(CACHE)='Y' ORDER BY TABLE_NAME;


rem -----------------------------------------------------------------------
rem Purpose:    identifying the tables in CACHE. and generate script for
rem changing CACHE to NOCACHE
rem -----------------------------------------------------------------------

SELECT TABLE_NAME,CACHE
FROM DBA_TABLES WHERE CACHE='    Y' ORDER BY TABLE_NAME;

SELECT 'ALTER TABLE '||TABLE_NAME||' NOCACHE;'
FROM DBA_TABLES WHERE CACHE='    Y' ORDER BY TABLE_NAME;