Thread: flashback table

Can any one tell me about flashback table?
is it something like log files?

hi mangaivarma.

can you explain me for what that feature should be used?

oh.. thanks shenoy.
thats has a big log file to do rollback to a big level. right?

shenoy.. Can we use this flashback table to retrieve the new rows alone?

select from table_emp where empno not in historical data in flashback table on a particular date

This is just the skeleton of the query i think.(not the exact query)

Then how to query and retrieve the flashback table.
anyone please give me some materials regarding that.

Hi barbie, the flashback table is the new feature introduced in the oracle database 10g. This feature is used mainly for retrieving an accidentally dropped table. Lets say there is a table named sampletab sql> select * from tab; tname tabtype clusterid ------------------------ ------- ---------- sampletab table if the sampletab table was dropped accidentally, then the tab select will give, sql> select * from tab; tname tabtype clusterid ------------------------------ ------- ---------- bin$04lhckjhsdermaaaaaanpw==$0 table eventhough the sampletab has been dropped, the table has not been disappeared completely. The dropped table will be renamed to a system-defined name. The table and its associated objects are placed in a logical container known as the "recycle bin," which is similar to the windows recycle bin. However, the objects are not moved from the tablespace they were in earlier; they still occupy the space there. Sql> show recyclebin original name recyclebin name object type drop time ---------------- ------------------------------ ------------ ------------------ sampletab bin$04lhckjhsdermaaaaaanpw==$0 table 2007-01-12:11:31:47 this shows the original name of the table, sampletab, as well as the new name in the recycle bin. To reinstate the table, all you have to do is use the flashback table command: sql> flashback table sampletab to before drop; flashback complete. Sql> select * from tab; tname tabtype clusterid ------------------------------ ------- ---------- sampletab table the table is reinstated effortlessly. If you check the recycle bin now, it will be empty. To free the occupied space in the original tablespace, the recyclebin has to be purged using: sql> purge recyclebin; hopefully the detailed explanation is understandable & clears ur doubts. *** mangai varma ***

It cleared my doubt.

thanks mangaivarma.

My earlier post has not been aligned properly, probabaly bcos the content is too long.
Anyway, the following link will be helpful

Understanding Flashback Concepts
Flashback Queries

*** Mangai Varma ***

thats much useful.

hi friends,

well a lot of things have been discussed on flash back, but i want to add one more thing, this feature is present in oracle 9i also.
check out for DBMS_FLASHBACK package in oracle 9i.

cheers,

regards,
RSY