Collections:
Turn On and Off Recycle Bin for the Session in Oracle
How To Turn On or Off Recycle Bin for the Session in Oracle?
✍: FYIcenter.com
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, 1748🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...