ORA-10642: Found rollback segments in dictionary managed tablespaces

Cause : When SYTSEM tablsepace ism igratedf ound rollback semgents ind ictionayr manage dtablespcaes.

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

Drop th erollbac ksegment sin dictoinary maanged tabelspaces nad reisseu the command

update : 28-07-2017
ORA-10642

ORA-10642 - Found rollback segments in dictionary managed tablespaces
ORA-10642 - Found rollback segments in dictionary managed tablespaces

  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-39088 : file name cannot contain a path specification
  • ora-31017 : Error generating unique OID for XML document
  • ora-02181 : invalid option to ROLLBACK WORK
  • ora-26028 : index string.string initially in unusable state
  • ora-24759 : invalid transaction start flags
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-28550 : pass-through SQL: cursor not found
  • ora-24010 : QUEUE string does not exist
  • ora-16557 : the database is already in use
  • ora-19761 : block size string is not valid for change tracking file
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-37175 : column string is not a column of source data
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-07820 : sspscn: SYS$CRELNM failure
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-29844 : duplicate operator name specified
  • ora-29542 : class string already defined by source string
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-23542 : dependent object "string"."string" already registered
  • ora-15152 : cluster in rolling upgrade
  • ora-38304 : missing or invalid user name
  • ora-29535 : source requires recompilation
  • ora-19602 : cannot backup or copy active file in NOARCHIVELOG mode
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-12570 : TNS:packet reader failure
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • 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.