ORA-28337: the specified index may not be defined on an encrypted column

Cause : Indexc olumnw as eihter a ufnctioanl, doamin, o rjoin nidex.

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


update : 16-08-2017

ORA-28337 - the specified index may not be defined on an encrypted column
ORA-28337 - the specified index may not be defined on an encrypted column

  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-29358 : resource plan string does not exist
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-27048 : skgfifi: file header information is invalid
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • ora-01078 : failure in processing system parameters
  • ora-24805 : LOB type mismatch
  • ora-22347 : No changes to type specified for ALTER TYPE
  • ora-07599 : spwat: $SCHDWK failure
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-37152 : MDX query error: (string)
  • ora-32303 : mviews with user-defined types cannot reference multiple master sites
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-02338 : missing or invalid column constraint specification
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-01224 : group number in header string does not match GROUP string
  • ora-28176 : incorrect certificate version
  • ora-16771 : failover to a physical standby database failed
  • ora-08199 : Flashback Table operation is not supported on this object
  • ora-06000 : NETASY: port open failure
  • ora-10654 : Table is of type temporary or external
  • ora-09765 : osnmop: fork failed
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-29827 : keyword USING is missing
  • ora-06419 : NETCMN: server can not start oracle
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-13622 : invalid recommendation annotation
  • ora-01562 : failed to extend rollback segment number string
  • ora-22850 : duplicate LOB storage option specificed
  • 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.