QSM-02182: PCT is enabled through a join dependency
- 1 Answers
- 2568 Views
- I also Faced
- E-Mail Answers
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 |
ORA-24851: failed to connect to shared subsystem
ORA-16403: shutdown in progress - remote connection is not permitted
PLS-00488: invalid variable declaration: object 'string' must be a type or subtype
ORA-02310: exceeded maximum number of allowable columns in table
ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view
RMAN-06106: this command requires that target database be mounted
ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.
ORA-27036: translation error, unable to expand file name
RMAN-08183: channel string: block restore complete, elapsed time: string
ORA-24411: Session pool already exists.
LSX-00151: invalid combination of attributes "ref" and "name"
ORA-26536: refresh was aborted because of conflicts caused by deferred transactions
Oracle Errors 
