Greetings,
I have been trying to disable the flashback functionality on a tablespace using the instructions from chapter 9 of the "Backup and Recovery Advanced User's Guide":
ALTER TABLESPACE <TABLESPACE_NAME> FLASHBACK OFF;
This does not work. When a table is dropped, the recyclebin is populated. I have also tried to disable the flaskback functionality for the entire Database as a workaround, but that suggested syntax does not work either.
While mounted, but not open:
ALTER DATABASE FLASHBACK OFF;
How may I disable the flashback feature so the recyclebin does not get populated?
Use "show recyclebin" to see if the recyclebin is being populated.
Linux RedHat ES 3.0
Oracle 10g 10.1.0.2
Any help is appreciated.
Thank You.