Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14312: Value string already exists in partition string

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  


ORA-34359: (MXDSS11) string appears twice in the alias list.

1 Answers  


ORA-19658: cannot inspect string - file is from different resetlogs

1 Answers  


ORA-32700: error occurred in DIAG Group Service

1 Answers  


EXP-00018: datatype (number) for column string, table string.string is not supported

1 Answers  


KUP-04002: error getting file size for file string

1 Answers  


LPX-00122: undefined ID "~S" in IDREF

1 Answers  


TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC

1 Answers  


ORA-27153: wait operation failed

1 Answers  


DRG-10310: servers were shutdown before processing request

1 Answers  


ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  


Categories