Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> drop datafile from system tablespace

drop datafile from system tablespace

From: <becak_com_at_my-deja.com>
Date: 2000/04/17
Message-ID: <8dg0ja$kuv$1@nnrp1.deja.com>#1/1

I have add another datafile on another disk 'N than that disc is broken just couple hour later......

I have used recover database it's said this can not be done coz missing the archived log.

I have try to remove those datafile using edit the result from backup controlfile to trace and remove the datafile, but the oracle wont startup coz the dictionary miss those datafile 'wich actually has gone'

is there any thing i could do to recover my data

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US