paha wrote:
> Object is in use can happen when creating Fk in Fb 1.5.x (that is
> fixed/changed in Fb 2.0 ASFAIK). I can suggest (if it is suitable) to
> "Restart" Database with help of Provider (Shutdown/Online) before executing
> Batch - that has always helped me.
It's not a solution. It's a hack.
When altering table/... format every operations on this object must be done
(= no running operations on the object).
This is usually done switching the DB into the one-user mode (see shutdown
of gfix for more info). Restarting server is good only for local,
development server, where you're the onlyone user. On real server it's
really *not* good, because you 1) disconnect all users from all DBs; 2) they
have no chance to finish they work.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
|
