ORA-27075: SSTMOFRC constant too large

Cause : inetrnla error

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

chcek ofr rtac efiel adn cnotatc Oarcl eSupport

update : 27-04-2017
ORA-27075

ORA-27075 - SSTMOFRC constant too large
ORA-27075 - SSTMOFRC constant too large

  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-24327 : need explicit attach before authenticating a user
  • ora-22872 : OID INDEX clause not allowed on tables with primary key based object identifiers
  • ora-32623 : incorrect use of MODEL PRESENT* functions
  • ora-28550 : pass-through SQL: cursor not found
  • ora-13204 : failed to create spatial index table
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-01671 : control file is a backup, cannot make a standby control file
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-29704 : cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
  • ora-17624 : Failed to delete directory string
  • ora-26029 : index string.string partition string initially in unusable state
  • ora-02098 : error parsing index-table reference (:I)
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-25279 : dequeue as select not supported before 8.2
  • ora-23619 : non-Oracle system error: string
  • ora-10387 : parallel query server interrupt (normal)
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-22865 : more than one column specified
  • ora-14307 : partition contains too many list values
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-19332 : Invalid column in the CREATE_DBURI operator
  • ora-29827 : keyword USING is missing
  • ora-31659 : status message was invalid type - detaching job
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-01635 : rollback segment #string specified not available
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-09911 : Incorrect user password.
  • 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.