Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Unanswered: ORA-00439: feature not enabled: OLAP Window Functions

    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.
    nn

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: ORA-00439: feature not enabled: OLAP Window Functions

    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.

  3. #3
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: ORA-00439: feature not enabled: OLAP Window Functions

    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.
    nn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •