Oracle - 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

2016-10-17, 415👍, 0💬

Popular Posts:

Difference Between G...

What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...