Re: Undo after drop table...

From: IM <ian_at_ianmurphy.freeserve.co.uk>
Date: 25 Nov 2005 07:57:15 -0800
Message-ID: <1132934235.843883.126430@o13g2000cwo.googlegroups.com>

Just to make a point to the OP too. You said you "commited a drop on a table". However, you do know that issuing DDL (of which DROP TABLE is a part) will automatically commit?

So if you do some DML (eg INSERT, UPDATE, DELETE) without committing but, before you issue a rollback you create or drop a table (or index or view or any such thing), any DML changes you made will be committed as well.

Sorry if you already knew this but your original message indicated (to me at least) that you didn't.

Cheers,

IM Received on Fri Nov 25 2005 - 09:57:15 CST