Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Turn On or Off Recycle Bin for the Session
How To Turn On or Off Recycle Bin for the Session? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: 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.
2007-05-04, 5170👍, 0💬
Popular Posts:
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...
If client side validation is enabled in your Web page, does that mean server side code is not run? W...
How To Specify Two Background Images on a Page? - CSS Tutorials - Page Layout and Background Image D...
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...