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

Popular Posts:

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...

MySQL Database Tutor...

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

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...

RAND() - Generating ...

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