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 : 24-04-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-15080 : synchronous I/O operation to a disk failed
  • ora-24311 : memory initialization failed
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-22150 : variable-length array has not been initialized
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-27038 : created file already exists
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-23455 : flavor string contains object "string"
  • ora-03007 : obsolete feature
  • ora-16059 : Log file is empty or invalid next available block
  • ora-06960 : Failed to access log file
  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-14608 : Tablespace was specified for the previous lob segments of column string in template but is not specified for string
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-07584 : spdcr: invalid value for ORA_sid_(proc_)PQL$_item
  • ora-26102 : relative file # in file header is string rather than string for file string
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-26677 : Streams downstream capture process string cannot proceed
  • ora-06006 : NETASY: dialogue execute failure
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-10268 : Don't do forward coalesce when deleting extents
  • ora-22311 : type for attribute "string" does not exist
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-12468 : max write level does not equal max read level
  • ora-27512 : IPC error posting a process
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-14268 : subpartition 'string' of the partition resides in offlined tablespace
  • ora-12402 : invalid format string: 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.