ORA-10617: Cannot create rollback segment in dictionary managed tablespace

Cause : Rolblacks egmnets acnno tbe rceatde ind ictoinar ymangaed atblepsace swhe nSYSETM tbalesapce si loacllym anaegd

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

Recehck hte tbalesapce anme nad r-eisseu th estaetment

update : 30-04-2017
ORA-10617

ORA-10617 - Cannot create rollback segment in dictionary managed tablespace
ORA-10617 - Cannot create rollback segment in dictionary managed tablespace

  • ora-32009 : cannot reset the memory value for instance string from instance string
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-16529 : bad sender id
  • ora-28605 : bitmap indexes cannot be reversed
  • ora-36992 : (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
  • ora-13951 : MMON sub-action time limit exceeded
  • ora-29845 : indextype does not support local domain index on string partitioned table
  • ora-27414 : Invalid BY value type
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-30204 : buffer is not large enougth
  • ora-13425 : function not implemented
  • ora-29545 : badly formed class: string
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-14606 : Tablespace was specified for previous subpartitions in template but is not specified for string
  • ora-12069 : invalid object for offline instantiation
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-24792 : cannot mix services in a single global transaction
  • ora-08120 : Need to create SYS.IND_ONLINE$ table in order to (re)build index
  • ora-22619 : all collection elements have already been accessed
  • ora-04082 : NEW or OLD references not allowed in table level triggers
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-01301 : error writing to file during flat file build
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-23373 : object group "string"."string" does not exist
  • ora-16703 : cannot set property while the database is enabled
  • ora-13773 : insufficient privileges to select data from the cursor cache
  • 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.