Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Rollback !
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).
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). Received on Tue Aug 27 2002 - 09:03:22 CDT