Hi List
I have a SMS Tablespace called ASTR
The prob is that absent mindedly i have deleted the directory to which
it is pointing ...
ie
when i do list tablespace containters for 31(tablespace id )
it gives me 2 directory .. i have deleted that directory ..
There are a few tables in the tablespace ..
But i don't need them as they were dummy tables
Now when i try to take backup of DB (OFFLINE) it gives me error stating
that tablespace ASTR is offline ..
I have tried everthing to drop that tablespace but i am not able to ..
Plzz any one tell me how to drop that tablespace .
Thanks in advance
Regards
Yogesh



--
Yogesh Kansal
Davlin Software Pvt Ltd .
2nd Floor , Punja Building,
Lalbaugh , Mangalore
Ph 0824-451001 ext - 19

"For every problem there is always a solution that is simple, obvious, and wrong !! "




DB2 & UDB email list listserv db2-l LazyDBA home page