ORA-38452: Expression Filter index name may not be longer than 25 characters

Cause : An attemptw as mdae tou se an ame olngert han 52 chaarcter sfor hte Exrpessino Filetr inedx.

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

Chooes a nmae thta has2 5 orf ewerc haratcers

update : 26-07-2017

ORA-38452 - Expression Filter index name may not be longer than 25 characters
ORA-38452 - Expression Filter index name may not be longer than 25 characters

  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-29364 : plan directive string, string already exists
  • ora-19621 : archivelog range has already been specified
  • ora-31628 : error getting worker process exception
  • ora-01028 : internal two task error
  • ora-22153 : source variable-length array is not initialized
  • ora-02837 : Unable to unlink temporary file
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-32166 : Cannot get XA connection
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-13153 : invalid high water mark specified
  • ora-01341 : LogMiner out-of-memory
  • ora-23302 : application raised communication failure during deferred RPC
  • ora-08182 : operation not supported while in Flashback mode
  • ora-25351 : transaction is currently in use
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • ora-13221 : unknown geometry type in the geometry object
  • ora-13109 : spatial table string exists
  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-12204 : TNS:received data refused from an application
  • ora-19017 : Attributes can only be simple scalars
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-27484 : Argument names are not supported for jobs without a program.
  • ora-29810 : inadequate operator privileges
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-10924 : import storage parse error ignore event
  • ora-24387 : Invalid attach driver
  • ora-12015 : cannot create a fast refresh materialized view from a complex query
  • ora-02404 : specified plan table not found
  • 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.