Problems Dropping Tablespace
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.
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width