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, 10338👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - How can you avoid deadlock in threading? A good and careful planning can ...
What is cross page posting? By default, button controls in ASP.NET pages post back to the same page ...
What print out will the folloging code produce? main() { char *p1=“name”; char *p2; p2=(char*)malloc...
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
What are some advantages and disadvantages of Java Sockets? Advantages of Java Sockets: Sockets are ...