RE: Very Urgent

Thanks Stephane for the update. Actually I cannot wait for long and looking for any goog advice and finally decided to do point in Time recovery and then with export and Import, the problen is been taken care. Actually I cannot shut down the Production Database and especially this database is around 300G with the Tablespace dropped is around 50 Gig.

Thanks Again

Indy Johal
Manager, Database Administration
PR Newswire
indy_johal_at_prnewswire.com
http://www.prnewswire.com

(201) 946-5687 [W]
(201) 400-3960 [M]

"We tell your story to the world."

"Stephane Faroult" <sfaroult_at_oriolecorp.com> 06/02/03 03:37 AM
Please respond to "Stephane Faroult"  

        To:     ORACLE-L_at_fatcity.com
        cc:     Indy_Johal_at_prnewswire.com
        Subject:        RE: Very Urgent

I fear there is not much you can do, short of restoring the backups you fortunately have. Dropping the tablespace invalidates many things, updates the control file, etc. I presume that the tablespace was dropped with the 'including contents' clause, which means that for Oracle the data in it simply no longer belongs to the database. A bit too late for generating what would have allowed you to plug the tablespace back into the database.

>----- ------- Original Message ------- -----
>From: :ORACLE-L_at_fatcity.com
>To: ORACLE-L_at_fatcity.com
>Sent: Mon, 02 Jun 2003 03:19:38
>
>Please Reply Ur Suggestion at the earliest
>
>One of DBA had dropped the Wrong tablespace for the
>PArtitioned table. The
>Datafile exist on the system. How to recover the
>Tablespace as it contains
>crucial data. RMAN backup also available along with
>Archive as well as
>Correct timing of Dropping the Datafile
>
>
>Thanks

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Indy Johal
  INET: Indy_Johal_at_prnewswire.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).