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 : 24-06-2017
ORA-29893

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-38768 : resizing datafile string failed
  • ora-18001 : no options specified for ALTER OUTLINE
  • ora-16071 : dependency archived log file not found string
  • ora-02055 : distributed update operation failed; rollback required
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-31613 : Master process string failed during startup.
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-39137 : cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-31186 : Document contains too many nodes
  • ora-00000 : normal, successful completion
  • ora-39047 : Jobs of type string cannot use multiple execution streams.
  • ora-04045 : errors during recompilation/revalidation of string.string
  • ora-16553 : the Data Guard broker process (DMON) failed to shutdown
  • ora-12334 : database (link name string) is still open
  • ora-23399 : generation of replication support for "string"."string" is not complete
  • ora-23483 : object "string"."string" not allowed in this operation.
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-13867 : Database-wide SQL tracing is already enabled
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-04941 : required operating system patch needs to be applied
  • ora-09790 : sllfcf: unable to close file.
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-27012 : skgfrd: read from file failed
  • 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.