Oracle-L: Re:Rollback !

From: <dgoulet_at_vicr.com>
Date: Tue, 27 Aug 2002 06:03:22 -0800
Message-ID: <F001.004C02EB.20020827060322@fatcity.com>

Prakash,

Drop table is a Data Definition command which does an implicit commit afterwards. It also does not create a rollback record so no you can't roll it back. What you have to do is recover another copy of the database elsewhere to the point just before the drop, then export the table & re-import it into your database.

As far as I know 9i is compatible with XP. We just don't run Oracle (RDBMS) on Microslop products around here, too unreliable.

Dick Goulet

____________________Reply Separator____________________
Author: "guess who" <yours_in_at_rediffmail.com>
Date:       8/26/2002 7:43 PM

1.) Can we rollback a drop statement ?

for example : drop table emp;

i want to recover this table in a easiest way....

2.) Can we install oracle 9i in windows XP professional...Whether it suits and i want to know whether there is no startup problem for the database.....

help....

Regards,
Prakash.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: guess who
INET: yours_in_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------