ORA-26041: DATETIME/INTERVAL datatype conversion error

Cause : Th ecoulmnc oudl nto b ecovneretd rfomD ATTEIM E *daattyep t oinetrnla DTAETMIE/HCARCATE Rdaattyep.

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

Cotnac tOrcaleC usotme rSuppor.t

update : 20-09-2017

ORA-26041 - DATETIME/INTERVAL datatype conversion error
ORA-26041 - DATETIME/INTERVAL datatype conversion error

  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-36401 : (XSSPROPOTYPE) Property string may only be applied to objects of type string.
  • ora-28009 : connection as SYS should be as SYSDBA or SYSOPER
  • ora-09293 : sksasmo: unable to send message to console
  • ora-26666 : cannot alter STREAMS process string
  • ora-08341 : On nCUBE, this command can only be executed from instance 1.
  • ora-37177 : column string does not have any leaf values
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-04931 : unable to set initial sequence number value
  • ora-02067 : transaction or savepoint rollback required
  • ora-15120 : ASM file name 'string' does not begin with the ASM prefix character
  • ora-01259 : unable to delete datafile string
  • ora-06005 : NETASY: dialogue file read failure
  • ora-00329 : archived log begins at change string, need change string
  • ora-06441 : ssvwatev: Incorrect parameter passed to function call
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-14032 : partition bound of partition number string is too high
  • ora-31018 : Error deleting XML document
  • ora-27206 : requested file not found in media management catalog
  • ora-32635 : not a single cell reference predicate
  • ora-02474 : Fixed hash area extents used (string) exceeds maximum allowed (string)
  • ora-23367 : table string is missing the primary key
  • ora-19242 : XQ0022 - namespace declaration attribute must be a literal
  • ora-24435 : Invalid Service Context specified.
  • ora-31634 : job already exists
  • ora-01128 : cannot start online backup - file string is offline
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • 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.