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-14039: partitioning columns must form a subset of key
columns of a UNIQUE index



ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index..

Answer / guest

Cause: User attempted to create a UNIQUE partitioned index
whose partitioning columns do not form a subset of its key
columns which is illegal

Action: If the user, indeed, desired to create an index
whose partitioning columns do not form a subset of its key
columns, it must be created as non-UNIQUE; otherwise,
correct the list of key and/or partitioning columns to
ensure that the index' partitioning columns form a subset of
its key columns

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06026: some targets not found - aborting restore

1 Answers  


NNL-00019: warning: server either changed or ignored your request

1 Answers  


ORA-02297: cannot disable constraint (string.string) - dependencies exist

1 Answers  


ORA-16136: Managed Standby Recovery not active

2 Answers  


QSM-02067: no partition key or PMARKER or join dependent expression in select list

1 Answers  


TNS-12171: TNS:could not resolve connect identifier: string

1 Answers  


ORA-13155: invalid number of dimensions specified

1 Answers  


ORA-15073: diskgroup string is mounted by another ASM instance

1 Answers  


ORA-22313: cannot use two versions of the same type "string"

1 Answers  


NNO-00634: received authoritative name "string" when we are its authority

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


Categories