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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
