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 : 26-05-2017
ORA-25957

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

  • ora-13138 : could not determine name of object string
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-02329 : column of datatype string cannot be unique or a primary key
  • ora-04076 : invalid NEW or OLD specification
  • ora-19234 : XQ0014 - invalid or unsupported must-understand extension
  • ora-24402 : error occured while creating connections in the pool
  • ora-12712 : new character set must be a superset of old character set
  • ora-12714 : invalid national character set specified
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-08235 : smsget: listener not on this node
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-01529 : error closing file 'string'
  • ora-08208 : ora_addr: cannot read from address file
  • ora-27160 : process requested to perform operation
  • ora-32335 : dimension must have at least one level
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-15026 : disk 'string' is not an ASM disk
  • ora-01669 : standby database control file not consistent
  • ora-02075 : another instance changed state of transaction string
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-36342 : (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ AGGREGATES | CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]
  • ora-00290 : operating system archival error occurred. See error below
  • ora-02352 : file truncated error
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-16575 : request terminated at broker discretion
  • 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.