Re: Couldn't drop dbspace
In article <6nkdv3$8av@news.itfs.nsk.su>,
"Ivan Lyakhovenko" <van@xtech.ru> wrote:
Hi Ivan,
>
> Hi Gurus!
>
> I've got a very strange problem:
> I'm using OnLine 7.10UC1 in SCO3.2.v4.2.
> When I'm trying to drop a non-root dbspace, Informix says that this dbspace
> is not empty. Onstat -d says that this dbspace really has non-empty pages (a
> lot of pages!!!). BUT I'm sure, that there are NO databases and tables on
> this space. What happen? How could I clean up this space or how could I drop
> non-empty dbspace?
Most probably you have an extent of table from another dbspace in this
dbspace. Run oncheck -pe to find this out. If you do find such a situation,
you will need to unload the table and drop the dbspace and load the table
again.
>
> Any advises will be appreciated.
> Thank you in advance.
>
HTH,
Ravi...
> --
> Ivan Lyakhovenko, project manager, xTech Ltd.
> Novosibirsk, Russia.
> mailto:van@xTech.ru
> http://www.xTech.ru
--
Ravi Joseph Pinto, Senior Consultant, AFL Infotech,
Mumbai, India
mailto:rjpinto@my-dejanews.com
‰
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum