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

AMD-00155: Object to delete "string" does not exist in Workspace "string"

1 Answers  


ORA-19704: file name exceeds maximum length of string

1 Answers  


ORA-24304: datatype not allowed for this call

1 Answers  


ORA-06808: TLI Driver: could not link IPX and ethernet streams

1 Answers  


ORA-21526: initialization failed

1 Answers  


ORA-31202: DBMS_LDAP: LDAP client/server error: string

1 Answers  


EXP-00057: Failure to initialize parameter manager

1 Answers  


TNS-12569: TNS:packet checksum failure

1 Answers  


SQL*Loader-00128: unable to begin a session

1 Answers  


ORA-30437: all job queue processes have stopped running

1 Answers  


ORA-07268: szguns: getpwuid error.

1 Answers  


ORA-30370: set operators are not supported in this context

1 Answers  


Categories