OLAP not enabled !?

From: Harald Henkel <H.Henkel_at_GS-automation.DE>
Date: Thu, 23 May 2002 11:00:17 +0200
Message-ID: <3CECAFA1.943974D3@GS-automation.DE>

Hello everybody.

I received the follwing error on creating a view:

CREATE OR REPLACE VIEW VIEW_MAP_WEIGHTS AS *
FEHLER in Zeile 1:
ORA-00439: Funktion nicht aktiviert: OLAP Window Functions

In english:
ERROR in line 1:
ORA-00439: Feature not enabled: OLAP Window Functions

The view had SELECTion lines like

...

       dense_rank() over (order by df_coor0) as weight0,  
       decode ( df_coor1, null, 0, dense_rank() over (partition by
df_coor0 order by df_coor1)) as weight1,  
       decode ( df_coor2, null, 0, dense_rank() over (partition by

df_coor0,df_coor1 order by df_coor2)) as weight2,
...

The feature seems to be installed (no ORA-00438). So, what could be missing ?

I found in the docs a relation between OLAP and Oracle Trace. Do I have to activate Oracle Trace (oracle_trace_enable = TRUE) ?

Thanks for any reply,
Harald Henkel

-- 
Harald Henkel

GS automation GmbH
Dornierstr. 4
82178 Puchheim
Germany
Tel:    + 49-89-890095-79
Fax:    + 49-89-890095-80
Mobile: + 49-178-7829126
e-mail: H.Henkel_at_GS-automation.DE
Web:    www.GS-automation.DE

Received on Thu May 23 2002 - 04:00:17 CDT