ORA-00439: feature not enabled: OLAP Window Functions

NoviceNo1 · #1 (**permalink**) 01-13-03, 02:22

Hi,
When I run the following query, I get the error
ORA-00439: feature not enabled: OLAP Window Functions

How do I enable this feature ?

The query is

SELECT deptno,
empno,
sal,
sum(sal) over(partition by deptno order by deptno) Total
FROM emp a,
dual b
WHERE to_char(a.deptno) = b.dummy(+)
ORDER BY deptno

Any help would be of great use.

andrewst · #2 (**permalink**) 01-13-03, 05:17

Quote:

Originally posted by NoviceNo1
Hi,
When I run the following query, I get the error
ORA-00439: feature not enabled: OLAP Window Functions

How do I enable this feature ?

The query is

SELECT deptno,
empno,
sal,
sum(sal) over(partition by deptno order by deptno) Total
FROM emp a,
dual b
WHERE to_char(a.deptno) = b.dummy(+)
ORDER BY deptno

Any help would be of great use.

You need to have Oracle Enterprise Edition or Personal Edition (not Standard Edition) to use these functions.

NoviceNo1 · #3 (**permalink**) 01-13-03, 07:03

Quote:

Originally posted by andrewst
You need to have Oracle Enterprise Edition or Personal Edition (not Standard Edition) to use these functions.

Hi,
Thanks for the info.
We have Oracle Enterprise Edition. It is installed on Solaris.
Does that mean i have to Reinstall Oracle.
If I have to Reinstall, i need to take a backup of the database
and reinstallit right.

Internet Services

Web Development

Digital Marketing

Consumer Tech