Flashback technology in Oracle

Flashback technology


Flashback provides a set of features to recover data back.This technology provides analyze and repair human errors.

WE CAN ROLLBACK THE DROPPED TABLES IN ORACLE.
THE SYNTAX IS

flashback table username.tablename(dropped tablename) to before drop

example
flashback table hcls.employee to before drop

hcls ------> connection name
employee  ------------> dropped table name

REVOVER THE DROPPED TABLE WITH ANOTHERNAME(RENAME THE DROPPED TABLE)

SYNTAX:


flashback table username.tablename(dropped tablename) to before drop rename to tablename(new table name or old tablename


flashback table "UIDAII"."TAMILNS" to before drop rename to NAGERC


UIDAII  -------> CONNECTION NAME
TAMILNS ------->DROPPED TABLE NAME