dbTalk Databases Forums  

How to drop dbspace that does not exists (ASA 9.0.2)

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss How to drop dbspace that does not exists (ASA 9.0.2) in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrei Iliev
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.