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.
⇒ Show All Tables in Your Schema in Oracle
⇐ Empty Your Recycle Bin in Oracle
2019-05-10, 1613🔥, 0💬
Related Topics:
