ORA-23515: materialized views and/or their indices exist in the tablespace

Cause : An attempt was made to drop a tablespace which contains materialized views and/or their indices.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Drop the materialized views in this tablespace. Also, find indices belonging to materialized views in this tablespace and drop then. Then try dropping the tablespace.

update : 24-06-2017

ORA-23515 - materialized views and/or their indices exist in the tablespace
ORA-23515 - materialized views and/or their indices exist in the tablespace

  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-09749 : pws_look_up: port lookup failure
  • ora-38721 : Invalid file number.
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-28174 : Kerberos ticket not provided by proxy
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-29927 : error in executing the ODCIStatsCollect / ODCIStatsDelete routine
  • ora-24156 : duplicate table alias string
  • ora-01103 : database name 'string' in control file is not 'string'
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-16706 : no resource guard is available
  • ora-15066 : offlining disk "string" may result in a data loss
  • ora-06575 : Package or function string is in an invalid state
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-36996 : (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
  • ora-26735 : operation not allowed on the specified file group version
  • ora-29807 : specified operator does not exist
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-19816 : WARNING: Files may exist in string that are not known to database.
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-12335 : database (link name string) is not open
  • ora-25531 : MTTR specified is too small: string
  • ora-24142 : invalid ruleset name
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.