Re: Flashback Technology of Oracle 10g

Terminator wrote:
>
> As this technology was invented in the Oracle 9i. But in the Oracle 10g
> the DDL flashback was introduced, as with the recycle bin funda. I am
> creating a index on the table and then when I am deleting the index the
> index is been not seen in the recycle bin, But it is seen in the
> user_objects as a deleted recylce bin item name. How to recover that.
> Please can anyone tell me the procedure.
>
> Best Regards,
> Terminator

there is also 'flashback database' which is a different mechanism to flashing back either tables or queries.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------