ORA-14304: List partitioning method expects a single partitioning column

Cause : number of columns in a partitioning column list exceeded the legal limit of 1 for List partitioned objects

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

modify partitioning column list so that it consists of at most 1 column

update : 25-06-2017

ORA-14304 - List partitioning method expects a single partitioning column
ORA-14304 - List partitioning method expects a single partitioning column

  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-26015 : Array column string in table string is not supported by direct path
  • ora-01929 : no privileges to GRANT
  • ora-13195 : failed to generate maximum tile value
  • ora-12631 : Username retrieval failed
  • ora-02787 : Unable to allocate memory for segment list
  • ora-29302 : database is not open clone
  • ora-23385 : replication parallel push string argument not valid
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-13509 : error encountered during updates to a AWR table
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-01515 : error dropping log group string: no such log
  • ora-24129 : table name string does not start with string prefix
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-13485 : error occurred during compression or decompression: string
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-12843 : pdml lock not held properly on the table
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-12196 : TNS:received an error from TNS
  • ora-12226 : TNS:operating system resource quota exceeded
  • ora-29871 : invalid alter option for a domain index
  • ora-08310 : sllfop: Bad value for recsize
  • 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.