I tried dropping a table and then when i viewed the recycle bin nothing was there in it . Earlier too i dropped tables many a times but I was surprised to find no objects whatsover in it . What's the deal ?
i had tried
SHOW PARAMETER RECYCLEBIN;
Its VALUE column shows it as ON . So fine here !
Then i droppped an existing table but still the command
Select object_name from recyclebin;
and any such retrieval of columns is showing
NO ROWS SELECTED !!
flashback command confirms that recyclebin is not having any such dropped tables !!
So where are dropped tables going ?
And one more thing :
This time i tried using
ALTER SYSTEM SET RECYCLEBIN=ON;
Alter session and sqlplus throws an error :
Specified initialization parameter is not modifiable with this option
So, is this because that i am working as a SYSTEM ?? i have not created any other USER as of now .