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.
2019-05-14, 794👍, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...