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

RMAN-06483: changed datafile copy expired

1 Answers  


RMAN-06589: cannot specify DB_FILE_NAME_CONVERT option without AS COPY

1 Answers  


ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

1 Answers  


ORA-16570: operation requires restart of database "string"

1 Answers  


RMAN-08537: channel string: skipped, autobackup already found

1 Answers  


RMAN-08000: channel string: copied datafile string

1 Answers  


RMAN-06707: could not initialize for output file: "string"

1 Answers  


ORA-00344: unable to re-create online log 'string'

1 Answers  


ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


ORA-13447: GeoRaster metadata BRS error

1 Answers  


LPX-00655: Invalid output comment '~S'.

1 Answers  


ORA-13413: null or invalid resampling parameter

1 Answers  


Categories