Re: Rollback !

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
chao_ping_at_vip.163.com

• 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: 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).

• = = = = = = = = = = = = = = = = = = =

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡zhu chao
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡chaospku_at_163.net
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2002-08-27

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: zhu chao
  INET: chaospku_at_163.net

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).