OraFAQ Forum: SQL & PL/SQL » ORA-00439: feature not enabled: OLAP Window Functions

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00439: feature not enabled: OLAP Window Functions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00439: feature not enabled: OLAP Window Functions [message #230451]

Thu, 12 April 2007 01:10

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

Hi,
We're currently testing one java application on Oracle 8i Standard Edition, it works well on EE. We encounter this error


ORA-00439: feature not enabled: OLAP Window Functions

On this part when executing:



SELECT * FROM 
(SELECT ROW_NUMBER() OVER (ORDER BY FILEDATE ASC) AS RN, 
        TO_CHAR(FILEDATE,'YYYY/MM/DD HH24:MI:SS') AS TEST_DATE,
        TO_CHAR(LOAD_TIME,'YYYY/MM/DD HH24:MI:SS') AS COLLECT_DATE,
        LOCATION,LOT,WLOT,FLOT,SUBLOT,PROGRAM,PROGRAM_VER,DEVICE,
        WDEVICE,FDEVICE,CATEGORY,TESTERTYPE,TESTERNAME,TEST_MODE,
        TEMPATURE,TOTAL_QTY,YIELD,REJECT_QTY,DATALOG_QTY,
        FILESIZE,FILEPATH,REPORTS, DECODE(COMPRESSED_FLAG, 'M', 'M', 'C', 'C', 'N') AS COMPRESSED_FLAG, 
        TPLOADPATH 
  FROM METADATA 
  WHERE FILEDATE BETWEEN TO_DATE('2007-04-11 00:00:00','YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2007-04-12 23:59:59','YYYY-MM-DD HH24:MI:SS') 
  AND DECODE(COMPRESSED_FLAG, 'C', 'Y', 'M', 'Y', 'N') = 'N' ) 
WHERE RN > 0 AND RN <= 10

I had some search and I it said it was not supported or something. Is there any workaround on this sql? Thank you very much sir/mam

Regards,
Rhani

Report message to a moderator

Re: ORA-00439: feature not enabled: OLAP Window Functions [message #230453 is a reply to message #230451]

Thu, 12 April 2007 01:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Upgrade to EE, or better yet, upgrade to a supported version of the database?

Report message to a moderator

Re: ORA-00439: feature not enabled: OLAP Window Functions [message #230486 is a reply to message #230453]

Thu, 12 April 2007 02:09

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

Hi,
I think they're trying to reduce the license to SE so we're checking if we could validate the application for SE. Thanks again, I'll see if I could recode the SQL to work without using analytic functions.

UPDATE:

I've recode it to this, Im just not sure if there are any problem to be on using rownum, thanks, will this sove it?


select *
from (
     select rownum as rn,
TO_CHAR(FILEDATE,'YYYY/MM/DD HH24:MI:SS') AS TEST_DATE,
        TO_CHAR(LOAD_TIME,'YYYY/MM/DD HH24:MI:SS') AS COLLECT_DATE,
        LOCATION,LOT,WLOT,FLOT,SUBLOT,PROGRAM,PROGRAM_VER,DEVICE,
        WDEVICE,FDEVICE,CATEGORY,TESTERTYPE,TESTERNAME,TEST_MODE,
        TEMPATURE,TOTAL_QTY,YIELD,REJECT_QTY,DATALOG_QTY,
        FILESIZE,FILEPATH,REPORTS, DECODE(COMPRESSED_FLAG, 'M', 'M', 'C', 'C', 'N') AS COMPRESSED_FLAG, 
        TPLOADPATH 
  FROM METADATA 
  WHERE FILEDATE BETWEEN TO_DATE('2007-03-25 00:00:00','YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2007-04-12 23:59:59','YYYY-MM-DD HH24:MI:SS') 
  AND DECODE(COMPRESSED_FLAG, 'C', 'Y', 'M', 'Y', 'N') = 'N'
)
where rn > 5 and rn < 11

Regards,
Rhani

[Updated on: Thu, 12 April 2007 02:53]

Report message to a moderator

Previous Topic:	Could Oracle work on Windows Vista?
Next Topic:	select from table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 30 21:06:59 CDT 2025