What Is a Recycle Bin in Oracle

What Is a Recycle Bin in Oracle

Q

What Is a 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.

⇒Oracle Database Basic Concepts

⇒⇒Oracle Database Tutorials

2020-10-26, 847👍, 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...

"ALTER TABLE ... ALT...

How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...

sys.sql_modules - Ge...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...