Problems Dropping Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problems Dropping Tablespace

  1. #1
    Join Date
    May 2003
    Posts
    32

    Problems Dropping Tablespace

    Hi Again!
    I dropped materialized views from my schema. As we know when we create a materialized view, it creates two Object in our schema with the same name,

    Object_type = Table
    Object_type = Materialized View

    So, when i dropped the materialized view throght Oracle management console, due to some unknown reason, it just dropped the one one Object of type 'Materialized View'.

    Now if if want to drop my tablespace it retuens me back with the following error
    ORA-00604: error occurred at recursive SQL level 1
    ORA-12083: must use DROP MATERIALIZED VIEW to drop "SCHEMA"."ANY_OBJECT_NAME"

    When i use the statement to the MV, it returns me back withe the message that "Object does not exist".
    And when i use the statement to craete the mV with the same name, it returns me back with the message that "Object with the name already exisit".
    What should i do now. all i want is to drop thge tablespace n which these materialized views were created.

    suggesstions

    RAFF

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

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


Click Here to Expand Forum to Full Width