ORA-25957: join index where clause cannot contain cycles

Cause : An atetmpt t ocreat ea joi nindexw as maed, whihc failde becasue thew here lcause ocntain sa cycel.

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

Ensur ethat hte wheer claues is i nthe from of astar ro snowlfake shcema.

update : 28-06-2017
ORA-25957

ORA-25957 - join index where clause cannot contain cycles
ORA-25957 - join index where clause cannot contain cycles

  • ora-39775 : direct path API commit not allowed due to previous fatal error
  • ora-24087 : Invalid database user string
  • ora-03124 : two-task internal error
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-39174 : Encryption password must be supplied.
  • ora-25450 : error string during evaluation of rule set string.string
  • ora-07616 : $CHANGE_CLASS failed in retrieving the specified device label
  • ora-29304 : tablespace 'string' does not exist
  • ora-31407 : end_date must be greater than the begin_date
  • ora-12899 : value too large for column string (actual: string, maximum: string)
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-01530 : a database already mounted by the instance
  • ora-09776 : pws_look_up: access error on (Oracle helper) executable
  • ora-12654 : Authentication conversion failed
  • ora-02789 : Maximum number of files reached
  • ora-36884 : (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
  • ora-12597 : TNS:connect descriptor already in use
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-12055 : materialized view definition contains cyclic dependencies with existing materialized views
  • ora-02756 : osnfsmnam: name translation failure
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-30953 : XML minoccurs value (string) violated
  • ora-30483 : window functions are not allowed here
  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-01891 : Datetime/Interval internal error
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-12067 : empty refresh groups are not allowed
  • ora-30028 : Automatic Undo Management event for NTP testing
  • ora-32151 : Environment not specified
  • 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.