guess who,
hi,
1. Rollback can only rollback dml statement,while drop is a ddl statement,so it is
impossible. To recover from a drop statement, you have to do incomplete recovery. Or
maybe you will try tablespace in time recovery.Or if data is not that important, do
imp from a backup.
2. You can install 9i on xp. It is a certified combination.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
======= 2002-08-26 19:43:00 ,you wrote£º=======
>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).
= = = = = = = = = = = = = = = = = = = =
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡zhu chao
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡[EMAIL PROTECTED]
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2002-08-27
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: zhu chao
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).
