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-27156: request for process information failed

1 Answers  


RMAN-06595: platform name 'string' does not match database platform name 'string'

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


ORA-25461: rule set not specified

1 Answers  


ORA-15006: template "string" does not exist

1 Answers  


ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.

1 Answers  


ORA-24172: rule set string.string has errors

1 Answers  


ORA-01483: invalid length for DATE or NUMBER bind variable

1 Answers  


TNS-12643: Client received internal error from server

1 Answers  


ORA-01935: missing user or role name

2 Answers  


PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


ORA-19851: OS error while managing auxiliary database string

1 Answers  


Categories