Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02182: PCT is enabled through a join dependency
- 1 Answers
- 3195 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 |
NNF-02001: NIS client error string: string
ORA-32605: invalid REBUILD option
ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
RMAN-06545: "string" is an invalid response - please re-enter.
LSX-00283: referenced notation "~S" is not defined
ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].
QSM-01026: query rewrite is disabled for, string
PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC
NNL-00340: Trace file name is currently string
ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
ORA-30035: Undo tablespace cannot be specified as default temporary tablespace
RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE
Oracle Errors 
