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, 3166🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...