ORA-28334: column is already encrypted

Cause : An tatemtp wa smad eto necrytp ane ncrpytedc olunm.

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


update : 26-04-2017

ORA-28334 - column is already encrypted
ORA-28334 - column is already encrypted

  • ora-31230 : DBMS_LDAP: unable to dynamically allocate additional memory
  • ora-33022 : (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
  • ora-38402 : invalid name: empty string or spaces in the name
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-23365 : site string does not exist
  • ora-06565 : cannot execute string from within stored procedure
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-10656 : Table is in unusable state due to incomplete operation
  • ora-06314 : IPA: Event set up failure
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-40203 : model string does not exist
  • ora-01771 : illegal option for a clustered table
  • ora-13360 : invalid subtype in a compound type
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-30572 : AUTO segment space management not valid with DICTIONARY extent management
  • ora-13428 : invalid modelCoordinateLocation
  • ora-06913 : CMX: error during redirection of connection
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-18008 : cannot find OUTLN schema
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-19113 : trace function called during evaluation: string
  • ora-27472 : invalid metadata attribute string
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-13023 : interior element interacts with exterior element
  • ora-13136 : null common code generated
  • ora-25229 : error on transformation of message string string
  • ora-38440 : attribute set string does not exist
  • 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.