Quote Originally Posted by davey23uk
because it was either turned off or never turned on, you need to turn it on in the mount stage
Thanks davey....
but when you do

SQL> ALTER SYSTEM SET RECYCLEBIN = 'ON';

System altered.

...and get "SYSTEM ALTERED", doesn't it mean that this parameter is modifiable on the go? Else why doesn't it fail and ask you to do it at mount time?

again thanks...