QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or

QSM-02183: Expression to enable PCT not in PARTITION BY of
analytic function or SPREADSHEET

Question Posted / guest

1 Answers
9123 Views
I also Faced
E-Mail Answers

QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET..

Answer / guest

Cause: The capability in question is not supported when the
expression is not in the PARTITION BY clause

Action: Change the query so that the expression is in the
PARTITION BY

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13757: "SQL Tuning Set" "string" is active.

1 Answers

QSM-01020: materialized view, string, is ineligible

1 Answers

ORA-09284: sllfop: cannot allocate read buffer

1 Answers

SQL-02126: Count of array elements cannot be negative (i.e. < 0)

1 Answers

NNL-00300: Cancelled server cache dump

1 Answers

ORA-39707: compatibile parameter string too high for downgrade to string

1 Answers

ORA-04078: OLD and NEW values cannot be identical

1 Answers

ORA-38455: Expression Filter index should be created by the owner.

1 Answers

ORA-16541: site is not enabled

1 Answers

ORA-30334: illegal dimension level name

1 Answers

ORA-31464: target table for the change table no longer exists

1 Answers

ORA-00313: open failed for members of log group string of thread string

1 Answers

For more Oracle Errors Interview Questions Click Here