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-12485: new effective label not within effective clearance

1 Answers  


ORA-12815: value for INSTANCES must be greater than 0

1 Answers  


ORA-39959: invalid warning number (string)

1 Answers  


ORA-16562: intended_state not used here, syntax error at "string"

1 Answers  


ORA-19709: numeric parameter must be non-negative integer

1 Answers  


RMAN-05510: Duplicate finished

1 Answers  


TNS-00083: (USER or ADMIN) in the argument field

1 Answers  


PLS-00405: subquery not allowed in this context

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


ORA-32027: There is no string column with the matching type in string.string.

1 Answers  


ORA-06559: wrong datatype requested, string, actual datatype is string

1 Answers  


NNL-00873: Fastest update processing time: string

1 Answers  


Categories