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
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 188.8.131.52.0 - 64bit Production
PL/SQL Release 184.108.40.206.0 - Production
CORE 220.127.116.11.0 Production
TNS for IBM/AIX RISC System/6000: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production
I would appreciate if any one can help me on this.