0

After accidentally dropping a package body in Oracle Application Express 4.0.2.00.09, I tried to restore it from the recycle bin.

The object however does not appear in that folder, along with other numerous objects I have dropped in the past.

Using Flashback has had no effect either. Has anyone else ever experienced this? Does anyone know how to solve this?

Ian Carpenter
  • 8,346
  • 6
  • 50
  • 82
user2747399
  • 1

1 Answers1

1

The recyclebin only stores dropped tables (and their associated bits and pieces like indexes and triggers).

Database packages, views and other objects are dropped permanently. You need to restore from a backup or version control software.

Jeffrey Kemp
  • 59,135
  • 14
  • 106
  • 158