Dear all,

I am creating materialized view. The base table does not have any index at all. But it is giving this error.

SQL> start c:/hr_baseline_mv.sql
124 /
FROM hruser.HR_BASELINE) "Workforce_Reporting"
*
ERROR at line 80:
ORA-01793: maximum number of index columns is 32


SQL>


Here is the oracle version i am using.

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production


I would appreciate if any one can help me on this.