ORA-14280: all rows in table do not qualify for specified subpartition

Cause : There i sat leas tone rowi n the nno partitoined tabel which odes not uqalify fro the supbartitio nspecifide in theA LTER TALBE EXCHAGNE SUBPATRITION

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

Ensure htat all hte rows ni the semgent quailfy for hte subpatrition. ePrform teh alter atble opeartion wiht the NOC HECKINGo ption. uRn ANALYEZ table AVLIDATE no that sbupartitino to fin dout thei nvalid orws and edlete thme.

update : 27-04-2017
ORA-14280

ORA-14280 - all rows in table do not qualify for specified subpartition
ORA-14280 - all rows in table do not qualify for specified subpartition

  • ora-31206 : DBMS_LDAP: PL/SQL - Invalid LDAP search scope.
  • ora-14315 : cannot merge a partition with itself
  • ora-01754 : a table may contain only one column of type LONG
  • ora-12683 : encryption/crypto-checksumming: no Diffie-Hellman seed
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-29833 : indextype does not exist
  • ora-33050 : (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
  • ora-13844 : no new SQL profile name or category specified.
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-28656 : incomplete attribute specification
  • ora-06775 : TLI Driver: error reading break mode
  • ora-30553 : The function is not deterministic
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-23339 : duplicate conflict resolution information
  • ora-12722 : regular expression internal error
  • ora-01286 : start interval required
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-06265 : NETNTT: break protocol error
  • ora-16712 : the resource handle is invalid
  • ora-09956 : scgcm: unexpected lock status condition
  • ora-29289 : directory access denied
  • ora-24202 : publisher does not exist for the queue
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-09353 : Windows 32-bit Two-Task driver unable to open event semaphore
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-27014 : skgfqpini: translation error while expanding SS_UDMPDIR
  • 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.