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-02334: cannot infer type for column

1 Answers  


PCC-00028: Option "string" not legal as EXEC ORACLE OPTION

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  


ORA-16628: The broker protection mode is inconsistent with the database setting.

1 Answers  


ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  


ORA-25263: no message in queue string.string with message ID string

1 Answers  


LCD-00209: missing value for keyword at end of string [string]

1 Answers  


ORA-28235: algorithm not available

1 Answers  


ORA-14164: subpartition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL

1 Answers  


ORA-01974: Illegal archive option

1 Answers  


Categories