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 : 29-06-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-06025 : NETASY: Configuration error
  • ora-12489 : default label not within clearance range
  • ora-16099 : internal error ORA-00600 occurred at standby database
  • ora-16060 : Log file is current
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-39200 : Link name "string" is invalid.
  • ora-29278 : SMTP transient error: string
  • ora-13388 : invalid value for dst_spec parameter
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-23606 : invalid object string
  • ora-00956 : missing or invalid auditing option
  • ora-19904 : test recovery not allowed for datafile string
  • ora-00155 : cannot perform work outside of global transaction
  • ora-02853 : Invalid server list latch time out value
  • ora-16235 : DDL skipped because import has occurred
  • ora-09314 : sltln: error translating logical name
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-13906 : The tablepace is not of the right type.
  • ora-28177 : incorrect Kerberos ticket version
  • ora-27034 : maximum length of ORACLE_SID exceeded
  • ora-19506 : failed to create sequential file, name="string", parms="string"
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-06264 : NETNTT: data protocol error
  • ora-38307 : object not in RECYCLE BIN
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-04034 : unable to shrink pool to specified size
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-06256 : NETNTT: remote fork failed
  • 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.