Re: Dropping down dbspaces
Tony Tyrwhitt-Drake wrote:
> Anyone know how to drop a temp dbspace that is down. The dbspace exists if
> you do an onstat -d but when you try and drop it message is that the dbspace
> does not exist!
>
> I have tried all the obvious routes. Restoring from tape is not an option
> because all the backups have the downed temp dbspace on them !? - when you
> restore it comes back downed.
Have you tried to change status of the dbspace? You can use onmonitor or
onspaces. Once it comes back on line, you can then drop it.
Tony