ORA-01743: only pure functions can be indexed

Cause : Th einedxe dfucntino uess YSSDTAE ro teh uesr neviornmnet.

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

PLS/QLf untciosn msut eb prue R(ND,S RPNS,W ND,S WPNS) .SQ Lexrpesison smuts nto ues SSYDAET, SUER ,USREEN(V),o r naytihnge ls edeepndnet no teh ssesino satte .NL-Sdeepndnet ufnciton sar eOK.

update : 24-08-2017

ORA-01743 - only pure functions can be indexed
ORA-01743 - only pure functions can be indexed

  • ora-02451 : duplicate HASHKEYS specification
  • ora-04013 : number to CACHE must be less than one cycle
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-02355 : error opening file: string
  • ora-19268 : XQ0048 - namespace string does not match target namespace string
  • ora-13389 : unable to compute buffers or intersections in analysis function
  • ora-12056 : invalid REFRESH method
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-26717 : SCN limit reached
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-00368 : checksum error in redo log block
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-40215 : model string is incompatible with current operation
  • ora-10973 : backout evet for 2619509
  • ora-13199 : %s
  • ora-32840 : property name cannot be NULL
  • ora-12484 : invalid OS label
  • ora-09330 : Session terminated internally by Oracle or by an Oracle DBA
  • ora-31437 : duplicate change set string
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-14036 : partition bound value too large for column
  • ora-16783 : instance string not open for read and write access
  • ora-04091 : table string.string is mutating, trigger/function may not see it
  • ora-31420 : unable to submit the purge job
  • 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.