Problem when creating Dimension in Oracle 10g Express Edition

I have a problem when I want to create a dimension using Oracle Database 10g Express Edition and i got the following error message ORA-00439 materialized view rewrite –开发者_JAVA技巧 feature not enabled. I need your help please.

A DIMENSION object is intended to support certain QUERY REWRITE operations in data warehouses. As the error message suggests, Oracle XE does not support this functionality. Find out more.

This is not unreasonable: a datawarehouse which could fit into XE's storage limitations (4GB) would be pretty poor. So, the question is, why are you trying to build a Data Warehouse in XE?

Join a fact table and a number of dimension tables needs a PL/SQL code.

Thanks.