Oracle: Replace corrupted first datafile

Vote count:

0

(I'm aware this is not the perfect place for this question, but stackoverflow has the largest audience amongst all stackexchange networks, and i'm in terrible fix over this)

A datafile associated with a tablespace has been corrupted (got truncated to size 0). I don't mind losing the data, because I have a full DB dump which I can import. Now I want to replace this datafile, or provide this tablespace with a new datafile so that the corrupted one can be ignored.

I cannot drop the tablespace because it is spread over multiple partitions. I cannot bring this corrupted file online because it throws an IO error when doing so.

So the only option is : replace this datafile, or add a new one.

If I just add a new datafile, will this new datafile be used and the corrupted one be left alone?

asked 25 secs ago

sanjeev mk

1,398