alter database flush buffer_cache seem not working!
871977Jun 6 2012 — edited Jun 10 2012Hi all,
SQL> create tablespace test datafile '/u01/test.dbf' size 1m;
Tablespace created.
SQL> create table test tablespace test as select * from hr.employees;
Table created.
SQL>
SQL>
SQL> select count(*) from test;
COUNT(*)
----------
107
SQL> !rm /u01/test.dbf
SQL> !ls /u01/test.dbf
ls: /u01/test.dbf: No such file or directory
SQL> alter system flush buffer_cache;
System altered.
SQL> SQL>
SQL> select count(*) from test;
COUNT(*)
----------
107
SQL>
Why my flush buffer_cache does not take affect?
Thank you!
Dan.