Turn On and Off Recycle Bin for the Session in Oracle

Q

How To Turn On or Off Recycle Bin for the Session in Oracle?

✍: FYIcenter.com

A

If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script:

SQL> connect HR/fyicenter
Connected.

SQL> SELECT COUNT(*) FROM recyclebin;
  COUNT(*)
----------
         0

SQL> ALTER SESSION SET recyclebin = off;
Session altered.

SQL> CREATE TABLE emp_dept_90 
  2  AS SELECT * FROM employees WHERE department_id=90;
Table created.

SQL> DROP TABLE emp_dept_90;
Table dropped.

SQL> SELECT COUNT(*) FROM recyclebin;
  COUNT(*)
----------
         0

Warning: Turning off the recycle bin feature in your session will give yourself hard times on recovering dropped tables.

 

Managing Oracle Database Tables

⇒⇒Oracle Database Tutorials

2016-10-17, 205👍, 0💬