Oracle - Recycle Bin - Storage to Hold Dropped Tables in Oracle

Recycle Bin - Storage to Hold Dropped Tables in Oracle

Q

What Is Recycle Bin in Oracle?

✍: FYIcenter.com

A

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.

⇒Managing Oracle Database Tables

⇒⇒Oracle Database Tutorials

2016-10-17, 373👍, 0💬

Popular Posts:

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...

AdventureWorksLT - D...

How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...