Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to add a deleted datafile again
Turkbear, normally you can add a new datafile to a tablespace however
in the thread we are talking about a tablespace that has had a file
removed from it via the alter database drop datafile command. We had
to do this in the past but I think we removed all the files associated
with the tablespace so we may not have had a choice. But because the
dictionary will have references to the objects stored in the file I
believe dropping the tablespace including contents will be necessary to
clean up the dictionary entries and bring the database to a consistent
view.
HTH -- Mark D Powell -- Received on Thu Feb 10 2005 - 08:24:43 CST