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-12016: materialized view does not include all primary
key columns



ORA-12016: materialized view does not include all primary key columns..

Answer / guest

Cause: The query that instantiates the materialized view did
not include all of the columns in the master's primary key
constraint.

Action: Include all of the master's primary key columns in
the materialized view query or create a ROWID materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00327: log string of thread string, physical size string less than needed string

1 Answers  


ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


TNS-00251: Failure in nstest:

1 Answers  


LSX-00152: only "minOccurs", "maxOccurs", or "id" is allowed

1 Answers  


ORA-40108: input data contains too few distinct target (string) values

1 Answers  


ORA-03209: DBMS_ADMIN_PACKAGE invalid file/block specification

1 Answers  


ORA-02069: global_names parameter must be set to TRUE for this operation

1 Answers  


QSM-00775: the specified SQL statement cannot be stored in the workload due to invalid table references

1 Answers  


ORA-00281: media recovery may not be performed using dispatcher

1 Answers  


ORA-01374: _log_parallelism_max greater than 1 not supported in this release

1 Answers  


ORA-01936: cannot specify owner when creating users or roles

1 Answers  


PCC-02332: attempted to redefine SQL identifier

1 Answers  


Categories