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 : 29-04-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-01622 : thread number must be specified - default not specific
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-27451 : %s cannot be NULL
  • ora-23439 : refresh group template already exists
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • ora-09318 : slkhst: unable to host out to operating system
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-36988 : (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-32336 : cannot use USING NO INDEX to create materialized view "string"."string"
  • ora-07272 : spwat: invalid semaphore set id.
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-26056 : Requested direct path operation on a view is not supported.
  • ora-30121 : 'string' is not an allowable value for 'string'
  • ora-19112 : error raised during evaluation: string
  • ora-37018 : (XSACQUIRE03) Multiwriter operations are not supported for object workspace object.
  • ora-28005 : invalid logon flags
  • ora-07275 : unable to send signal to process
  • ora-22600 : encountered 8.0.2 (Beta) VARRAY data that cannot be processed
  • ora-30440 : can't fast refresh;refresh complete or set event 30441 for partial refresh
  • ora-30975 : invalid Order Key Index option for XML Index
  • ora-13833 : SQL profile named string doesn't exist
  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-01507 : database not mounted
  • ora-28044 : unsupported directory type
  • 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.