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...


QSM-02182: PCT is enabled through a join dependency



QSM-02182: PCT is enabled through a join dependency..

Answer / guest

Cause: The capability in question is not supported when the
materialized view does not contain some expression join
dependent on the partitioning key of relation in question in
the select list. For definition of join dependency, please
look at Oracle

Action: Change the query to contain the partitioning key

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-00574: rman aborting due to errors read/writing dbms_pipe

1 Answers  


QSM-02013: SELECT list includes a RAW data type expression

1 Answers  


PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported.

1 Answers  


ORA-32627: illegal pattern in MODEL FOR LIKE loop

1 Answers  


ORA-16125: large transaction string string string is waiting for more data

1 Answers  


ORA-23350: maximum number of recursive calls exceeded

1 Answers  


ORA-00361: cannot remove last log member string for group string

1 Answers  


PCB-00010: SQLCHECK value in EXEC ORACLE statement exceeds command line value

1 Answers  


QSM-02115: mv references a remote object and is refreshed ON COMMIT

1 Answers  


TNS-12153: TNS:not connected

1 Answers  


NCR-04022: NCRR: Invalid procedure descriptor

1 Answers  


DGM-16943: You must connect to instance "string" and issue the command again.

1 Answers  


Categories