Originally posted by jrpm
in off hours, put the datafile back online, re-size it to something minimal, like 16K, or as small as you can. Turn off autoextensibility (if it is on). Then forget about it. It will be online but with no usable free space it won't be used.
hi, because the archivelog file is missing so unable to online it.
If i can online it, then everything is ok.
Maybe the only choice is rebuild the whole tablespace? sigh.