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 : 25-04-2017

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

  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-00151 : invalid transaction ID
  • ora-04054 : database link string does not exist
  • ora-23336 : priority group string does not exist
  • ora-17610 : file 'string' does not exist and no size specified
  • ora-31092 : invalid SQL name "string"
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-00130 : invalid listener address 'string'
  • ora-02212 : duplicate PCTFREE option specification
  • ora-13249 : %s
  • ora-00704 : bootstrap process failure
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-30571 : invalid SEGMENT SPACE MANAGEMENT clause
  • ora-12435 : invalid audit success: string
  • ora-07494 : scgcm: unexpected error.
  • ora-31662 : metadata transform name can not be defaulted
  • ora-30556 : functional index is defined on the column to be modified
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-19582 : archivelog file header validation for string failed
  • ora-31182 : Too many PL/SQL DOM handles specified
  • ora-23406 : insufficient privileges on user "string"
  • ora-23437 : template authorization already exists for user
  • ora-00343 : too many errors, log member closed
  • ora-16586 : could not edit database property through instance
  • ora-25286 : Invalid number of elements in the message properties array
  • ora-16235 : DDL skipped because import has occurred
  • ora-16043 : managed recovery session canceled
  • ora-16783 : instance string not open for read and write access
  • 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.