ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.

Cause : When deifning a ARNGE parittion tepmlate wiht a concta dimensoin for teh partitoin dimenison, theu ser attmepted tod efine ar ange usnig the forma tof a cocnat dimesnion valeu.

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

Use jus tthe lea fvalue. nIstead o f"VALUESL ESS THA N", ujst say," VALUES ELSS THANv alue".

update : 18-08-2017
ORA-36673

ORA-36673 - (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
ORA-36673 - (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.

  • ora-23404 : refresh group "string"."string" does not exist
  • ora-06753 : TLI Driver: name-to-address mapping failed
  • ora-32408 : materialized view log on "string"."string" already has new values
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-32143 : Environment not specified
  • ora-02064 : distributed operation not supported
  • ora-12982 : cannot drop column from a nested table
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-22338 : must specify CASCADE INCLUDING DATA when altering the final property
  • ora-13524 : error encountered while retrieving baseline information
  • ora-13143 : invalid POLYGON window definition
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-14007 : missing LESS keyword
  • ora-02363 : error reading from file: string
  • ora-32730 : Command cannot be executed on remote instance
  • ora-35587 : (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.
  • ora-00321 : log string of thread string, cannot update log file header
  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-29552 : verification warning: string
  • ora-12569 : TNS:packet checksum failure
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-06733 : TLI Driver: failed to receive disconnect
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-23617 : Block string for script string has already been executed
  • ora-37120 : MDX string is null
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-29665 : Java thread deadlock detected
  • 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.