Thursday, October 05, 2006

Oracle 10g Recyclebin

To disable the recycle bin:

ALTER SESSION SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF;

To enable the recycle bin:

ALTER SESSION SET recyclebin = ON;
ALTER SYSTEM SET recyclebin = ON;

To check what objects are in the recycle bin:

select * from user_recyclebin;
select * from dba_recyclebin;

To purge the objects in the recycle bin:

purge recyclebin;
purge dba_recyclebin;

No comments:

Full Guide for using Bitnami Prometheus Operator Helm Chart with Additional Scrape Configuration

"The Prometheus Operator for Kubernetes provides easy monitoring definitions for Kubernetes services and deployment and management of...