Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

Answer / guest

Cause: There is at least one row in the non partitioned
table which does not qualify for the subpartition specified
in the ALTER TABLE EXCHANGE SUBPARTITION

Action: Ensure that all the rows in the segment qualify for
the subpartition. Perform the alter table operation with the
NO CHECKING option. Run ANALYZE table VALIDATE on that
subpartition to find out the invalid rows and delete them.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14155: missing PARTITION or SUBPARTITION keyword

2 Answers   IBM,


ORA-30772: opaque types do not have default constructors

1 Answers  


ORA-15064: communication failure with ASM instance

1 Answers  


PCC-00108: This statement is not supported by ANSI

1 Answers  


ORA-01616: instance string (thread string) is open - cannot disable

1 Answers  


PLS-00659: constructor method must return SELF AS RESULT

1 Answers  


ORA-31014: Attempted to delete the root container

1 Answers  


IMP-00039: VOLSIZE does not match the value used for export: string

1 Answers  


ORA-14644: table is not subpartitioned by Hash method

1 Answers  


TNS-12623: TNS:operation is illegal in this state

1 Answers  


ORA-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


ORA-19908: datafile string has invalid checkpoint

1 Answers  


Categories