Discussion Locked

SQL error...Help please

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi there, very recently I downloaded and installed the Oralce 8i Personal edition on my PC.
At SQLPLUS prompt, I encountered the following error message. Could any one help me to resolve this?

select eno,enam,salary,dense_rank() over (partition by dept order by salary) from myp_employee
*
ERROR at line 1:
ORA-00439: feature not enabled: OLAP Window Functions

Thanks.

3 replies

by mail2sudha

Thanks Tim, the problem was with my Oracle8i Personal Edition where this feature is not enabled. Nothing wrong in the partition statement.
Thanks.

This discussion is closed to new replies.