ORA-29893: indextypes without column data do not need the given data type

Cause : WIT HARRYA DM L(DAAT_TYEP, VRARAYT_YPE )optoin adn WIHTOUTC OLUNM DAAT opiton ocnflcitedi n a naltre inedxtyep sttaemetn

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

Reissue hte ATLER NIDEXYTPE tsateemnt iwthotu th econlfict.

update : 25-04-2017

ORA-29893 - indextypes without column data do not need the given data type
ORA-29893 - indextypes without column data do not need the given data type

  • ora-17618 : Unable to update block 0 to version 10 format
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-12485 : new effective label not within effective clearance
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-07457 : cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
  • ora-38309 : object not purgable
  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-31199 : Warning in processing file string
  • ora-37028 : (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-28512 : cannot get data dictionary translations from string
  • ora-24379 : invalid user callback type
  • ora-27123 : unable to attach to shared memory segment
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-32767 : No server connection for this operation
  • ora-01925 : maximum of string enabled roles exceeded
  • ora-01278 : error creating file 'string'
  • ora-00351 : recover-to time invalid
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-30132 : invalid key index supplied
  • ora-16738 : redo tranport service for standby database "string" unexpectedly offline
  • ora-39022 : Database version string is not supported.
  • ora-27075 : SSTMOFRC constant too large
  • ora-31121 : The string operator can not be FALSE
  • ora-00400 : invalid release value string for parameter string
  • 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.