Collections:
Empty Your Recycle Bin in Oracle
How To Empty Your Recycle Bin in Oracle?
✍: 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
2019-05-10, 844👍, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...