Dropped tables are not going to Recycle Bin

database-tuningoracle

To start, I am a student and just getting my feet wet with Oracle.

Quick history

  • Virtual Box XP running Oracle express with SQL Developer.
  • Created a user and tablespace for myself. (Key here is I'm not on System)
  • I have checked to make sure my Recycle Bin is active with

    SHOW Parameter recyclebin;

    command.

  • I have also tried alter session to on.

Long story short Create table, add some data, drop table with standard drop command with no purge at the end and table does not go to recycle bin and hence can't use the flashback command to retreive it. Any idea as to why my recycle bin would not be functioning as it should, or am I missing something obvious? I am very green so assuming the latter 🙂
Any feedback would be appreciated!

Best Answer

Well with some digging on the Doc for Oracle 11g Express, it appears the flashback functionality is not supported. So this would be a good indication of why I'm having problems!!