Re: DDL/DML and rollback

> The table data (of the table being dropped) is not stored in undo for this
> operation, it need not be (in order to "rollback" the drop table). Rather, the
> UNDO for the dictionary information that would provide access to this table is
> stored in UNDO. That way, if the system were to fail 1/2 way through the drop
> table (before it finished) -- upon restart of the system -- the table would
> still be there, still be intact (the undo would be applied to the dictionary and
> it would be as if the operation never took place)

ok, if the system can rollback drop table statement after crash (using dictionary information written in UNDO) why the user can not rollback drop table statement ?

When drop table or truncate table is executed the data from table is left untouched. When is it deleted ?

How does High Water Mark is adjusted when i use truncate table statement and delete from statement ?

Thanx
Michal Received on Sun Feb 06 2005 - 04:20:05 CST