Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00439: feature not enabled: OLAP Window Functions
ORA-00439: feature not enabled: OLAP Window Functions [message #230451] Thu, 12 April 2007 01:10 Go to next message
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
Re: ORA-00439: feature not enabled: OLAP Window Functions [message #230453 is a reply to message #230451] Thu, 12 April 2007 01:15 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Upgrade to EE, or better yet, upgrade to a supported version of the database?
Re: ORA-00439: feature not enabled: OLAP Window Functions [message #230486 is a reply to message #230453] Thu, 12 April 2007 02:09 Go to previous message
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:
  


Current Time: Sun Dec 04 08:49:39 CST 2016

Total time taken to generate the page: 0.07613 seconds