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


Here is the oracle version i am using.

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

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