Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Problem with dropping the tablespace

    Hi folks

    Iam having problem with dropping the tablesapce.
    I dropped all the tables in the tablespace and tried to issue drop tablespace. Then it is complaining
    SQL0282N Table space "MMAX_IP" cannot be dropped because at least one of the
    tables in it, "MAXDATA.INV_PERPETUAL_B", has one or more of its parts in
    another table space. SQLSTATE=55024


    It looks like the table i have dropped have index in different tablespace.
    When i dropped the table the index was not removed.
    Should i be removing the index first before i drop the table ???

    I need to drop the tablesapce now and it is not allowing me to do it.
    Does any body here have any solution for this


    Thanks
    Prasad

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Problem with dropping the tablespace

    Indexes are dropped with table. Make sure you drop all the tables which reside in that tablespace. I have noticed that message myself and droping all the tables will do it for you.

    dollar

    Originally posted by koganti
    Hi folks

    Iam having problem with dropping the tablesapce.
    I dropped all the tables in the tablespace and tried to issue drop tablespace. Then it is complaining
    SQL0282N Table space "MMAX_IP" cannot be dropped because at least one of the
    tables in it, "MAXDATA.INV_PERPETUAL_B", has one or more of its parts in
    another table space. SQLSTATE=55024


    It looks like the table i have dropped have index in different tablespace.
    When i dropped the table the index was not removed.
    Should i be removing the index first before i drop the table ???

    I need to drop the tablesapce now and it is not allowing me to do it.
    Does any body here have any solution for this


    Thanks
    Prasad

Posting Permissions

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