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 Empty Your Recycle Bin
How To Empty Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: FYIcenter.com
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:
Here is an example script on how to use the PURGE statement:
SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE department_id=10; Table created. SQL> DROP TABLE emp_dept_10; Table dropped. 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(*) ---------- 5 SQL> PURGE TABLE emp_dept_90; Table purged. SQL> SELECT COUNT(*) FROM recyclebin; COUNT(*) ---------- 4 SQL> PURGE RECYCLEBIN; Recyclebin purged. SQL> SELECT COUNT(*) FROM recyclebin; COUNT(*) ---------- 0
2007-05-04, 10334👍, 0💬
Popular Posts:
What are the different accessibility levels defined in .NET ? Following are the five levels of acces...
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...
Where Do You Download JUnit? Where do I download JUnit? I don't think anyone will ask this question ...
How to create a thread in a program? You have two ways to do so. First, making your class "extends" ...
What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...