ORA-10980 in trace file while creating materialized view?"

I was getting ORA-10980 in trace files.
After granting all the permission still was not able to create the materialized view. but somehow putting driving_site hint and placing the local table on the right most I was able to create the mview.

SELECT /*+ DRIVING_SITE(cpf) DRIVING_SITE(dr) DRIVING_SITE(txn) DRIVING_SITE(tuc) DRIVING_SITE(rc) DRIVING_SITE(ru) */
mdevice.mPLACE_ID,
mdevice.mMODEL_ID,
TRUNC( cpf.dATE_TIME ) AS TXN_DATE,
COUNT(*) AS NUMBER_TXNS
FROM
FINANCIAL@MLINK cpf,
tDEVICE_RULE@MLINK dr,
tTXN_RULE@MLINK txn,
tTXN_USAGE_CLASSIFICATION@MLINK tuc,
tRULE_CLASSIFICATION@MLINK rc,
tRULE_USAGE@MLINK ru,
MV_MTREVICES mDevice
WHERE
--------