Results 1 to 2 of 2

Thread: SMS tablespace

  1. #1
    Join Date
    Aug 2002
    Location
    delhi, india
    Posts
    4

    Unanswered: SMS tablespace

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: SMS tablespace

    hmmm....I was in a similar situation but somehow I was able to find the delete directory (in our company they take system backup). Any chance you guys do the same? If you do list tablespace command it will tell you there that tablespace state is OFFLINE. Try doing restore, if you have a backup image...

    dollar

    Originally posted by yogeshkansal
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •