DBARECYCLEBIN gives administrators visibility to all dropped objects in recycle bin - Oracle Tables

Q.  In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?
- Published on 29 Jul 15

a. USER_RECYCLEBIN
b. DBA_RECYCLEBIN
c. Both A & B
d. None of the above

ANSWER: DBA_RECYCLEBIN
 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Oracle Database provides two views for obtaining information about objects in the recycle bin:

    - USER_RECYCLEBIN - This view can be used by users to see their own dropped objects in the recycle bin.
    - It has a synonym RECYCLEBIN, for ease of use.

    - DBA_RECYCLEBIN - This view gives administrators visibility to all dropped objects in the recycle bin.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)