Collections:
Recover a Dropped Table in Oracle
How To Recover a Dropped Table in Oracle?
✍: FYIcenter.com
If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table from the recycle bin as shown in the following SQL script:
SQL> CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE department_id=90; Table created. SQL> SELECT COUNT(*) FROM emp_dept_90; COUNT(*) ---------- 3 SQL> DROP TABLE emp_dept_90; Table dropped. SQL> FLASHBACK TABLE emp_dept_90 TO BEFORE DROP 2 RENAME TO emp_dept_bck; Flashback complete. SQL> SELECT COUNT(*) FROM emp_dept_bck; COUNT(*) ---------- 3
The FLASHBASK statement in this script recovered the dropped table "emp_dept_90" to new name "emp_dept_bck". All the data rows are recovered nicely.
⇒ Recycle Bin - Storage to Hold Dropped Tables in Oracle
⇐ Show All Columns in an Existing Table in Oracle
2019-05-14, 1616🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...