Collections:
Recycle Bin - Storage to Hold Dropped Tables in Oracle
What Is Recycle Bin in Oracle?
✍: FYIcenter.com
Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recycle save the same purpose as the recycle bin on your Windows desktop.
Recycle bin can be turned on or off in the recyclebin=on/off in your parameter file.
⇒ Turn On and Off Recycle Bin for the Instance in Oracle
⇐ Recover a Dropped Table in Oracle
2019-05-14, 3191🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...