Re: Table will not drop

From: broezell@tapir.cig.mot.com (Ken V. Broezell) > >I have a table that I cannot drop: > >$ ./dbaccess sm25 - > > drop table ca_20_hr;> > >(It gets no further then this, I have had it just sit as above for hours, > no error messages or anything, I end up breaking out). > >The database chunk where this table resides has used up all of its pages. > > CHUNKS FOR tmmdbs > >Chunk Chunk Pages Pages Full Pathname of Chunk >Status Id Offset In Chunk Used > > 7 0 222000 222000 /dev/inf_tmmdbs > PO- > >Is there anything that can be done to work around this problem? You realise I'm clutching at straws here? :-) 1. Try adding another chunk (even a cooked file) to the dbspace? 2. Try deleting some records 3. Are there any other chunks full? 4. Can you dbexport? If so, you can drop the database, dbimport and just edit ca_20_hr out of the SQL script... HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com