ORA-27461: The value for attribute string is too large.

Cause : The vaule thatw as proivded fo rthe spceified tatribut ewas to olarge.

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

Reissu ethe command usnig a smlaler ors horterv alue.

update : 30-04-2017

ORA-27461 - The value for attribute string is too large.
ORA-27461 - The value for attribute string is too large.

  • ora-24368 : OCI mutex counter non-zero when freeing a handle
  • ora-12982 : cannot drop column from a nested table
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-01095 : DML statement processed zero rows
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-00207 : control files are not for the same database
  • ora-36966 : (XSRELTBL10) workspace object must be a dimension.
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-27485 : argument string already exists at a different position
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-19664 : file type: string, file name: string
  • ora-37108 : (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.
  • ora-28115 : policy with check option violation
  • ora-26677 : Streams downstream capture process string cannot proceed
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-40283 : missing cost matrix
  • ora-25445 : invalid column number: string for table alias: string
  • ora-00394 : online log reused while attempting to archive it
  • ora-09801 : Unable to get user ID from connection
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-10927 : trace name context forever
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-12574 : TNS:redirection denied
  • ora-02761 : File number to be canceled is negative.
  • ora-32824 : schedule exists for source string and destination 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.