drop table and truncate table

[yxez]

Hi,

I just want to be sure....in Oracle10g u can rollback dropped tables
but not truncated ones right?

[Bore]

Speaking generally, yes.
If we should be correct, rollback as we do it normally will not bring back the data in both cases.
However for dropped table you can
flashback table to before drop
IF:
The table was not dropped using PURGE option\
The table was not dropped as a result of DROP USER CASCADE or Drop tablespace including contents
The space occupied by the table is still not reused
This is in plase operation, no shutdown is needed, no resetlogs, fast and easy
About the truncate, you need FLASHBACK DATABASE or incomplete recovery.
They both requires shutdown and RESETLOGS and brings the entire database back

Cheers

[yxez]

thanks dear