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-12403: invalid internal label

1 Answers  


EXP-00063: error in changing language handle

1 Answers  


TNS-12611: TNS:operation is not portable

1 Answers  


ORA-32060: channel failure

1 Answers  


PLS-00225: subprogram or cursor 'string' reference is out of scope

1 Answers  


DRG-11224: Third-party filter is unable to create or write to temporary file.

1 Answers  


ORA-33300: (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.

1 Answers  


O2U-00208: One or more characters in an attribute name were not legal identifier characters

1 Answers  


LPX-00229: input source is empty

1 Answers  


ORA-37008: (AWLISTALL06) number writers

1 Answers  


ORA-16197: Invalid DB_UNIQUE_NAME parameter specification

1 Answers  


RMAN-08087: channel string: started backup set validation

1 Answers  


Categories