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 : 24-09-2017
ORA-10642

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

  • ora-01565 : error in identifying file 'string'
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-08113 : composite partition index may not be compressed
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-12463 : undefined group string for policy string
  • ora-26028 : index string.string initially in unusable state
  • ora-06524 : Unsupported option : string
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-02801 : Operations timed out
  • ora-31468 : cannot process DDL change record
  • ora-26571 : %s.string.string: number of arguments (string) does not match replication catalog
  • ora-25956 : join index cannot be created on tables owned by SYS
  • ora-31014 : Attempted to delete the root container
  • ora-16164 : LGWR network server host detach error
  • ora-36671 : (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-27074 : unable to determine limit for open files
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-26098 : direct path context is not prepared
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-38606 : FI support threshold not between [0, 1]
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-39061 : import mode string conflicts with export mode string
  • ora-26764 : invalid parameter "string" for local capture "string"
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-00437 : ORACLE feature is not licensed. Contact Oracle Corp. for assistance
  • 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.