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, 334👍, 0💬

Popular Posts:

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Formatting Time Zone...

How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...

Oracle Database Tuto...

Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...