Re: Help with datafiles

if the datafile is simply an "older" backup copy of the file, i'd recommend you recover the database, which will apply changes from the archived log files.

if you don't have the archived log files, then i think you are going to have to drop the tablespace, and create a new tablespace, and import the objects from your latest valid export.

it's possible that oracle support has a technique for rescuing at least some of the data from some of the objects in the tablespace.

"Mark Wenham" <markwenham_at_prodigy.net> wrote in message news:97u1k3$50tm$1_at_newssvr06-en0.news.prodigy.com...
> Please can anyone help me ....
>
> Is it possible to remove a datafile once it has been created. I have user1
> and user2 files that are both datafiles belonging to the users tablespace.
>
> Very stupidly I overcopied a different version of user2 so that the
> tablespace now finds a dbwr file error (the files are slightly differnet
> sizes) when I try to bring it online. I do not have a copy of the original
> user2 that was overwritten. The only was around this as far as I can see
 is
> to somehow try and remove the user2 datafile from the tablespace. I do not
> want to drop the entire tablespace.
>
> If anyone can help I would be really grateful as I think I currently have
 an
> unusable database......
>
> Many thanks
>
> Mark
>
>
>
Received on Sun Mar 04 2001 - 16:04:35 CST