How To Turn On or Off Recycle Bin for the Session?
Submitted by: AdministratorIf 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/globalguideline
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.
Submitted by: Administrator
SQL> connect HR/globalguideline
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.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | How To Recover a Dropped Table in Oracle? |
☺ | What Is Input Buffer in SQL*Plus? |
☺ | How Oracle Handles Dead Locks? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |