ORA-23293: Cannot rename a column which is part of a join index

Cause : Th ecoulmnp aritciapte sina jion nide.x

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

Ify oun ee dtor enmae hte oclunm, oyu enedt o rdopt hej oi ninedx.

update : 25-04-2017
ORA-23293

ORA-23293 - Cannot rename a column which is part of a join index
ORA-23293 - Cannot rename a column which is part of a join index

  • ora-28166 : duplicate rolename in list
  • ora-25018 : conflicting trigger string already exists
  • ora-02463 : Duplicate HASH IS option specified
  • ora-07800 : slbtpd: invalid number
  • ora-09988 : error while detaching SGA
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-01071 : cannot perform operation without starting up ORACLE
  • ora-12951 : Attempt to change default permanent tablespace to temporary
  • ora-25469 : data not specified for alias: string column name: string
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-24758 : not attached to the requested transaction
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-38767 : flashback retention target parameter mismatch
  • ora-32812 : subscriber string does not exist
  • ora-13212 : failed to compare tile with the window object
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-07267 : spwat: invalid process number.
  • ora-35016 : (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
  • ora-31494 : could not activate a LogMiner session
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-24781 : branches don't belong to the same global transaction
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-01868 : the leading precision of the interval is too small
  • ora-07200 : slsid: oracle_sid not set.
  • ora-27501 : IPC error creating a port
  • ora-01080 : error in shutting down ORACLE
  • 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.