ORA-14264: table is not partitioned by Composite Range method

Cause : The table in the MODIFY DEFAULT ATTRIBUTES FOR PARTITION operation is partitioned by method other than Composite method

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

Ensure that the table is partitioned by Composite method

update : 28-06-2017

ORA-14264 - table is not partitioned by Composite Range method
ORA-14264 - table is not partitioned by Composite Range method

  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-21609 : memory being resized without being allocated first
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-04941 : required operating system patch needs to be applied
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • ora-01507 : database not mounted
  • ora-13188 : cell decode failed
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-00447 : fatal error in background process
  • ora-32823 : subscriber exists for queue string and destination string
  • ora-24778 : cannot open connections
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-13498 : %s
  • ora-24418 : Cannot open further sessions.
  • ora-00712 : cannot rename system tablespace
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-21704 : cannot terminate cache or connection without flushing first
  • ora-32506 : expecting one of string, string, or string but found string
  • ora-22956 : The set contains no elements
  • ora-13266 : error inserting data into table string
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-07407 : slbtpd: invalid exponent.
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-19010 : Cannot insert XML fragments
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-29836 : failed to validate referenced operators
  • ora-38957 : Target database not compatible
  • 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.