How to drop dbspace that does not exists (ASA 9.0.2) -
11-20-2007
, 06:28 AM
How to drop dbspace that does not exists anymore (it was deleted in the
file system)?
Real world example:
I had very large table in dbspace "blob". When dbspace reached abot
150Gb, I deciede to drop table and dbspace and start a new one. Drop
table statetment was to slowly for me (that table contain saveral
millons rows and was really huge). So I decieded to stop DB. Manually
delete blob.db file. Now I can drop dbspace "blob" (cause ASA things it
contais the table), I can drop that huge table either, course it doesn't
exist anymore. Dead cicle.
--
Iliev Andrei |