Oracle 8.1.7 Enabling Rank()?

I've launched (through ADO and OLEDB provider) this query on a Oracle 8.1.7 server:
SELECT * FROM
   (SELECT field1,... , fieldn, RANK() OVER ( ORDER BY field1,.., fieldn) AS counter_Rank FROM table

   WHERE field2=1 ORDER BY field3)
WHERE counter_Rank <= 100

It's a simple ranking query.
On my environment it works well.

In a similar environment (Oracle 8.1.7) i get this error: ORA-00439, feature not enabled: OLAP Window function

A lot of other queries works on the same machine. I bet the Olap windows function not enabled is 'rank()' Does someone knows how can i enable it?

thanks,
termoPilucco Received on Wed Aug 24 2005 - 08:28:48 CDT