Explain how to recover a dropped Table in Oracle

<<Previous  Next>>

Oracle - Explain how to recover a dropped Table in Oracle  - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

Explain how to recover a dropped Table in Oracle.

An oracle table that is accidentally dropped can be recovered using FLASHBACK command. When a table is dropped it stays in the recycle bin of Oracle until it is explicitly PURGED. Such tables can be recovered.

Example:
FLASHBACK TABLE TABLE_NAME TO BEFORE DROP;

Oracle - Explain how to recover a dropped Table in Oracle  - June 27, 2009 at 11:00 AM

Explain how to recover a dropped Table in Oracle.  

select * from recyclebin where original_name = 'table_name';

Then u can use
flashback table table_name to before drop;

Also read

Explain how to prevent tablespace fragmentation in oracle.

Tablespace fragmentation can be prevented by using PCTINCREASE command. PCTINCREASE is the percentage a new subsequent extent will grow...............

How many types of Tables supported by Oracle? Explain them

Ordinary (heap-organized) table, Clustered table, Index-organized table, Partitioned table...........

Explain how to view all columns in an Existing Table.

Use the command DESC and the table name to view the information about the columns..........

Explain how to recover a dropped Table in Oracle.

What is an Oracle Recycle Bin?

The tables that have been dropped can be retrieved back using the reycle bin feature of Oracle, they can be recovered back by the Flashback Drop action.............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience