I've got a problem with an index datafile. It was zipped accidently, during a db backup, so I've unzipped it. Now, the file in question is still in backup mode, when I check v$backup. I don't want to bounce the database, but need to get the datafile out of backup mode. When I do alter tablespace ... end backup, it says that I'm not accessing the current version. What should I do??
thanks in advance
If this is an index only tablespace can you just drop and recreate those indexes in a new tablespace?
Click Here to Expand Forum to Full Width