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-14099: all rows in table do not qualify for specified
partition



ORA-14099: all rows in table do not qualify for specified partition..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13752: User "string" must be SYS or must have the "ADMINISTER ANY SQL TUNING SET" privilege.

1 Answers  


RMAN-08040: full resync skipped, controlfile is not current or backup

1 Answers  


ORA-19610: directory block string is corrupt

1 Answers  


ORA-02004: security violation

1 Answers  


ORA-39310: illegal clean_failed_clone() call: it only applys to failed clones

1 Answers  


ORA-27093: could not delete directory

1 Answers  


NNC-00409: temporary name service failure

1 Answers  


DGM-16911: Warning:

1 Answers  


DRG-11837: Reauthorization Required

1 Answers  


QSM-00750: the specified value string for parameter string is invalid or contains an invalid item

1 Answers  


RMAN-06038: recovery catalog package detected an error

1 Answers  


ORA-02185: a token other than WORK follows COMMIT

1 Answers   IBM,


Categories