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

PCC-02317: illegal cast type expression

1 Answers  


RMAN-20031: resync not started

1 Answers  


RMAN-08181: media recovery complete, elapsed time: string

1 Answers  


ORA-07640: smsget: SGA not yet valid. Initialization in progress

1 Answers  


RMAN-06115: changed backup piece available

1 Answers  


TNS-01160: Trace level was not specified

1 Answers  


ORA-06953: Not enough virtual memory

1 Answers  


ORA-16059: Log file is empty or invalid next available block

1 Answers  


ORA-04933: initial service identifier is non-zero

1 Answers  


ORA-01302: dictionary build options missing or incorrect

1 Answers  


TNS-00027: INTCTL: Could not resolve Navigator's name/address

1 Answers  


PLS-00166: bad format for date, time or timestamp literal

1 Answers  


Categories