ORA-27149: assignment out of range

Cause : internal error, requested conversion too large for type

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

contact Oracle Support

update : 30-04-2017
ORA-27149

ORA-27149 - assignment out of range
ORA-27149 - assignment out of range

  • ora-01558 : out of transaction ID's in rollback segment string
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-12800 : system appears too busy for parallel query execution
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-12224 : TNS:no listener
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-29298 : Character set mismatch
  • ora-28580 : recursive external procedures are not supported
  • ora-26709 : Streams RFS restart
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-03132 : two-task default value overflow
  • ora-02074 : cannot string in a distributed transaction
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-28353 : failed to open wallet
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-31463 : logfile location string is an empty directory
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-23398 : user name "string" at database link "string" does not match local user name "string"
  • ora-09921 : Unable to get information label from connection
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-09919 : Unable to set label of dedicated server
  • ora-31099 : XDB Security Internal Error
  • ora-32152 : Cannot perform operation on a null number
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-36887 : (XSSRF06) Error rewriting OLAP DML expression. Column name string is not a valid ADT column.
  • 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.