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

Popular Posts:

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

What Causes Index Fr...

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