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-07406: slbtpd: invalid number.

1 Answers  


RMAN-08032: channel string: recid string stamp string does not match recovery catalog

1 Answers  


SQL*Loader-00820: cannot create where clause with range for table string

1 Answers  


TNS-00217: Total Bytes of Data : number

1 Answers  


NNL-00559: Shows, sets, or cancels the time for the next cache dump to the trace file

1 Answers  


PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal

1 Answers  


ORA-13750: User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.

1 Answers  


RMAN-10000: error parsing target database connect string "string"

1 Answers  


ORA-32033: unsupported column aliasing

3 Answers  


RMAN-06095: a backup controlfile must be restored to recover datafile string

1 Answers  


NZE-28814: Cannot convert a number in Oracle format to native format.

1 Answers  


TNS-12679: Native services disabled by other process but required

1 Answers  


Categories