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-05-2017

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

  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-07204 : sltln: name translation failed due to lack of output buffer space.
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-27047 : unable to read the header block of file
  • ora-13139 : could not obtain column definition for string
  • ora-36806 : (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
  • ora-00019 : maximum number of session licenses exceeded
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-32100 : operation invalid on transient object
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-12704 : character set mismatch
  • ora-02455 : The number of cluster key column must be 1
  • ora-29906 : indextype string.string does not exist
  • ora-07581 : spstp: cannot derive SID from unexpected process name
  • ora-04062 : %s of string has been changed
  • ora-30961 : internal SQL statement is too long
  • ora-29290 : invalid offset specified for seek
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-07220 : slspool: wait error.
  • ora-16797 : database is not using a server parameter file
  • ora-39766 : invaid stream specified for column array conversion
  • ora-06520 : PL/SQL: Error loading external library
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-19556 : required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
  • ora-29400 : data cartridge error string
  • 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.