ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

Cause : AVULSEL SE SHTNAo rTAc alsu eac nebu es dnoylw ti haRgn eaptrtioien datlbse

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

sU eAVULSE( vt )lcuaesw ti hiLtsp raititnodet baels

update : 18-08-2017
ORA-14310

ORA-14310 - VALUES LESS THAN or AT clause cannot be used with List partitioned tables
ORA-14310 - VALUES LESS THAN or AT clause cannot be used with List partitioned tables

  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-14069 : invalid TABLESPACE_NUMBER value
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-00447 : fatal error in background process
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-19201 : Datatype not supported
  • ora-12712 : new character set must be a superset of old character set
  • ora-37144 : (MDQUERY01) string is not a valid metadata object type for MDQUERY.
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-02354 : error in exporting/importing data string
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-24344 : success with compilation error
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-39043 : Object type string is not supported for string.
  • ora-09270 : szalloc: error allocating memory for security
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-19160 : XP0003 - syntax error: invalid variable name string
  • ora-13380 : network not found
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-13414 : invalid pyramid parameter
  • 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.