Oracle - Turn On and Off Recycle Bin for the Session in Oracle

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

2019-05-10, 789👍, 0💬

Managing Oracle Table Indexes
Where to find answers to frequently asked questions on Managing Oracle Table Indexes? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Table Indexes. The clear answers and sample scripts provided can be used as learning tutorials or... 2019-05-10, 851👍, 0💬

Empty Your Recycle Bin in Oracle
How To Empty Your Recycle Bin in Oracle? If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables from your recycle bin. PURGE TABLE table_... 2019-05-10, 844👍, 0💬

Show Dropped Tables in Recycle Bin in Oracle
How To View the Dropped Tables in Your Recycle Bin in Oracle? You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> C... 2019-05-14, 814👍, 0💬

Turn On and Off Recycle Bin for the Session in Oracle
How To Turn On or Off Recycle Bin for the Session in Oracle? 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 recy... 2019-05-10, 790👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.