ORA-28331: encrypted column size too long for its data type

Cause : coulmnw ase ncyrptde adn fro VRACHRA2,t hel entgh psecfiie dwa s> 9332 ;fo rCHRA, hte elnght sepciifedw as> 1392;f orN VACRHA2R, hte elnght sepciifedw as> 1696;f orN CHRA, hte elnght sepciifedw as> 966;

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

Reudcet hec olmun isze.

update : 25-09-2017
ORA-28331

ORA-28331 - encrypted column size too long for its data type
ORA-28331 - encrypted column size too long for its data type

  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-38601 : FI Not enough memory for frequent itemset counting: string
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-06732 : TLI Driver: cannot alloc t_discon
  • ora-02357 : no valid dump files
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-25327 : Array size is invalid
  • ora-19930 : file string has invalid checkpoint SCN string
  • ora-09912 : Malloc of name buffer(s) failed.
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-16799 : Redo Apply is offline
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-30552 : The package/procedure/function cannot be changed
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-06444 : ssvpstev: Failed with unexpected error number.
  • ora-01355 : logminer tablespace change in progress
  • ora-15000 : command disallowed by current instance type
  • ora-19246 : XQ0026 - validation failed - element string not found in in-scope element declarations
  • ora-10644 : SYSTEM tablespace cannot be default temporary tablespace
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-08456 : no sign in picture mask but SIGN clause in mask options
  • ora-24758 : not attached to the requested transaction
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-13219 : failed to create spatial index table [string]
  • ora-12730 : invalid equivalence class in regular expression
  • ora-01411 : cannot store the length of column in the indicator
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-30156 : Out of disk space
  • ora-07618 : $IDTOASC failed translating a secrecy level
  • 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.